Statistical measurements using Spreadsheet
Not what you're looking for?
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.
Purchase this Solution
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.
Purchase this Solution
Free BrainMass Quizzes
Paradigms and Frameworks of Management Research
This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.
Marketing Management Philosophies Quiz
A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.
Learning Lean
This quiz will help you understand the basic concepts of Lean.
Production and cost theory
Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.
Transformational Leadership
This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.