I need someone to make a line graph on excel and answer a few question based on the graph. I'll provide the data to make the line graph

User Generated

wbfgurea17

Business Finance

The University of Texas at Arlington

Description

 

Unformatted Attachment Preview

three per year The Social Security To protect your privacy, we write or visit any Social Security If you do not receive your Social Sec you with this receipt have your card in about 2 weeks. Any document(s s is a receipt to show that you applied for a Social S NDEZ Date: May 14, 201 GRAND PRAIRI. UN STATE SEC 2-4008 RD Have your instructor check this data sheet off at the end of class Record Data 1 4 3 Subject 5 6 N Resistance (kg) Recorded to the tenth place Rev for 0-5sec 8 Rev for 5-10sec q Rev for 10-15sec १ Rev for 15-20sec 7 Rev for Rev for 20-25sec 25-30sec 7 6 1 5.6 4.2 N 9 7 7 7 6 - 5 6 3 4.8 12 07 9 8 6 5 4 7. 3 10 OT 10 Б b 7 5 5 5.6 7 9 7 9 5 4 6 6.5 b 07 10 Б b L 7 7 5.7 lo 10 8 7 6 4 8 5.3 TT 10 ។ 8 9. 9 72 Class Sum Class Mean 75 42 2 44.3 5.5 Work ។ 9.4 302.4 315.8 69 8.6 289 60.50 7.5 6.3 252 212 5.3 178.1 Power be B 162 57.8 60.5 63.2 50.4 212.4 35.6 Resslone :مم axal resistance Do total reus/min(x) 6 a use Class - po worl time Appendix B: Grading Standards for Charts Line Chart 3 pts per 3 pts per 3 pts per 3 pts per 1. No category x-axis labels (if necessary) or labels written by hand 2. Category x-axis labels not centered properly 3. Category x-axis labels not written out 4. Category x-axis capitalization (1st letter in each word must be capitalized) note: no x-axis title is needed when x-axis labels are necessary 5. No line or line drawn by hand 6. No symbols or symbols drawn by hand 7. Symbols must be different when charting different conditions in one chart if not 8. No legend (if necessary) or legend written by hand 9. Incorrect legend 3 pts per 1 3 pts per 3 pts per 3 pts per 3 pts per Column Chart Same standards and deductions as 1-4, and 8-9 in line chart 1. Columns drawn by hand 2. Columns must have different patterns when charting different conditions in one chart, if not 3 pts per cond 3 pts per condi ASSIGN FORMAT FOR LAR ASSIGNMTUM 13. 14. Click on TRENDLINE. Choose a LINEAR trendline. You are now done with the "Add Chart Element" icon. 15. To put a BORDER around the chart: Click on FORMAT at the top of the page and the PAINT BUCKET ICON screen will appear. Click on SOLID LINE under the BORDER heading, and choose COLOR black. 16. To enter the correlation coefficient and the description. Click on INSERT at the top of the page then on TEXT BOX. Click on area of chart you want to type information in. Drag text under data and trendline. Creating a Line Chart: (note: A Line Chart needs a legend) 1. Place data in column A (X axis) and column B (Y axis). 2. Highlight both columns. 3. Click on INSERT at the top of the menu board 4. Click on INSERT at the top of the menu board 5. Click on LINE chart. 6. Click on LINE WITH MARKERS. 7. Click on upper right icon: MOVE CHART LOCATION and save as Chart 1, 2, 3 etc 48 O Numbers 8-14 below are under the "Add Chart Element" tab. 17. If needed to change the numbering or spacing on the X or Y axis Click on AXIS. This is done when the data is skewed left or to the top of the chart. Choose PRIMARY HORIZONTAL AXIS. Choose MORE AXIS OPTIONS. Organize the minimum and maximum numbers to achieve an even space on the top and bottom of the chart. Do the same for the vertical axis if needed. 18. Click on AXIS TITLE. Go to PRIMARY HORIZONTAL AXIS with the title at the bottom of the chart. Type in the axis title in the box provided. Don't forget units in parenthesis. 19. Click on AXIS TITLE. Go to PRIMARY VERTICLE AXIS with the title on the right side of the chart. Type in the axis title in the box provided. Don't forget units in parenthesis. 20. Click on CHART TITLE or type chart title in at the top of the chart and drag to the bottom left to line up with the zero axis. 21. Click on GRIDLINES. Choose PRIMARY MAJOR HORIZONTAL and choose NONE, choose PRIMARY MAJOR VERTICAL and choose NONE. 22. Click on LEGEND. Choose RIGHT for a LINE CHART. You are now done with the "Add Chart Element" icon. 23. To put a BORDER around the chart: Click on FORMAT at the top of the page and the PAINT BUCKET ICON screen will appear. Click on SOLID LINE under the BORDER heading, and choose COLOR black. 24. To enter the correlation coefficient and the description. Click on INSERT at the top of the page then on TEXT BOX. Click on area of chart you want to type information in. Drag text under data and trendline. Power = Work / Time = kgm/sec Jh Results 1. Create a line chart showing time (X) vs. power (Y). Use the class mean values for each time interval for data points on the graph. In a text box, include an explanation of what happened to power throughout the 30-sec test. Use the correlation to help explain (30 pts). 2. Calculate the correlation coefficient between time and power. Use the class mean values in your correlation calculation. (5 pts) Discussion Questions 1. a. What is the relationship between time and power? (5 pts) b. Was your correlation coefficient positive or negative and why? (5 pts) 2. At what time did peak power occur? Describe the significance of peak power. (5 pts) 3. What causes a decrease in work performed by the subject over time? (BE SPECIFIC) (10 pts) 35
Purchase answer to see full attachment
Explanation & Answer:
1 Project
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Fixed! I answered according to the data, but I do not know what kind of experiment you are reporting, so I could not provide you with longer answers. I need more context to give you more accurate answers.

Subject

Resistance
(kg)

1

Recorded
to the
Rev For
tenth place
0-5 sec
1
2
3
4
5
6
7
8
Class ...


Anonymous
Just what I needed…Fantastic!

Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Similar Content

Related Tags