Explore BrainMass
Share

Statistical measurements using Spreadsheet

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

a) Construct a scatter diagram for the following data:

x 1 2 3 4 5 6 7 8 9 10
y 10 10 11 12 12 13 15 18 21 25

x 11 12 13 14 15 16 17 18 19 20
y 26 29 33 39 46 60 79 88 100 130

Find the coefficient of correlation and the coefficient of determination. Now find the log of y and recalculate the two statistics and interpret your results.

b) The mileage recorded for a sample of company vehicles during a given week yielded the following data:
138 164 150 132 144 125 149 157
146 158 140 147 136 148 152 144
168 126 138 176 163 119 154 165
146 173 142 147 135 153 140 135
161 145 135 142 150 156 145 128

Determine the range, quartile deviation and standard deviation from these figures. The data below now becomes available on the mileages of the other ten cars belonging to the company.

234 204 267 198 179 210 260 290 198 199

Recalculate the range, quartile deviation and standard deviation, and comment on the changes to these statistics. You are also required to create a scatter graph and a histogram from the initial data using Microsoft Excel graphs and charts.

© BrainMass Inc. brainmass.com October 17, 2018, 4:26 am ad1c9bdddf
https://brainmass.com/business/business-math/statistical-measurements-spreadsheet-462300

Attachments

Solution Summary

The solution computes the scatter diagram, coefficient of correlation, coefficient of determination, range, quartile deviation and standard deviation from the given data.

The solutions are contained in two (2) spreadsheet files showing the detailed spreadsheet formula.

$2.19
Similar Posting

Correlation: wish to determine the correlation between the height (in inches) and weight (in pounds) of 21-year-old males...
3. All but one of the following statements contains ... 4. I want to examine the relationship between gas mileage of cars and the engine size ... 8. A statistics student computes the correlation between two variables in her spreadsheet, and finds ...

2. I wish to determine the correlation between the height (in inches) and weight (in pounds) of 21-year-old males. To do this, I measure the height and weight of two 21-year-old men. The measured values are

The correlation r computed from the measurements on these males is
A. 1.0
B. -1.0
C. near 0 because the heights and weights of the men are similar.

3. All but one of the following statements contains a blunder. Which one does not contain a blunder?
A. There is a correlation of r = 0.54 between the position a football player plays and his weight.
B. The correlation between amount of fertilizer and yield of tomatoes was found to be r = 0.33.
C. The correlation between the gas mileage of a car and its weight is r = 0.71 gallon-pounds.

4. I want to examine the relationship between gas mileage of cars and the engine size (displacement in cubic inches). The explanatory variable is
A. Engine size.
B. Gas mileage.
C. I could use either one.

8. A statistics student computes the correlation between two variables in her spreadsheet, and finds r = 0.06. She decides to conclude there is no relationship between the variables. Was she correct?
A. Yes
B. No
C. We don't have enough information.

View Full Posting Details