Business Statistics Homework
eddienoah
Assignment2.docxUSE EXCEL TO ANSWER THE FOLLOWING:
A container of one dozen large eggs was purchased at a local grocery store. Each egg was measured to determine its diameter (in millimeters) and weight (in grams). The results for the 12 eggs are given in the following table. Weight is the dependent variable. Calculate the r-sqr, correlation coefficient, and explain each value.
|
Index |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
|
Diameter (mm) |
42.2 |
45.45 |
47.8 |
47.4 |
47.7 |
43.5 |
44.4 |
43.9 |
46.2 |
45.9 |
44.3 |
44.5 |
|
Weight (grams) |
52.8 |
58.5 |
60.2 |
59 |
57.4 |
54.1 |
53.9 |
54.5 |
56.2 |
55.8 |
54.3 |
56.1 |
The following table gives information on the amount of sugar (in grams) and the calorie count in one serving of a sample of 13 varieties of Kellogg’s cereal. Calories is the dependent variable. Calculate the r-sqr, correlation coefficient, and explain each value.
|
Index |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
13 |
|
Sugar (grams) |
4 |
15 |
12 |
11 |
8 |
6 |
7 |
2 |
7 |
14 |
20 |
3 |
13 |
|
Calories |
120 |
200 |
140 |
110 |
120 |
80 |
190 |
100 |
120 |
190 |
190 |
110 |
120 |
