Store Square Feet Annual Sales
1.00 1.70 3.70
2.00 1.60 3.90
3.00 2.80 6.70
4.00 5.60 9.50
5.00 1.30 3.40
6.00 2.20 5.60
7.00 1.30 3.70
8.00 1.10 2.70
9.00 3.20 5.50
10.00 1.50 2.90
11.00 5.20 10.70
12.00 4.60 7.60
13.00 5.80 11.80
14.00 3.00 4.10
Using the data above, compute the following:
1 Covariance between Square Feet and Annual Sales
2 Correlation between Square Feet and Annual Sales
3 The variance of Square Feet (using n-1 and n)
4 The standard deviation of Annual Sales (using n-1 and n)
5 What is the sum of all Square Feet observations?
6 Create a new column of Annual Sales that are sorted from high to low
7 What is the range of Annual Sales?
8 What is the average number of Square Feet (compute the mean)?
9 Create a scatter diagram of Annual Sales (on the vertical) and Square Feet (on the Horizontal)
10 Provide both the intercept and slope of a simple linear regression model using this data
11 Is there a significant relationship between Annual Sales and Square Feet? How do you determine if there is a significant relationship?
Show all numerical results with four digits to the right of the decimal
1.00 1.70 3.70
2.00 1.60 3.90
3.00 2.80 6.70
4.00 5.60 9.50
5.00 1.30 3.40
6.00 2.20 5.60
7.00 1.30 3.70
8.00 1.10 2.70
9.00 3.20 5.50
10.00 1.50 2.90
11.00 5.20 10.70
12.00 4.60 7.60
13.00 5.80 11.80
14.00 3.00 4.10
Using the data above, compute the following:
1 Covariance between Square Feet and Annual Sales
2 Correlation between Square Feet and Annual Sales
3 The variance of Square Feet (using n-1 and n)
4 The standard deviation of Annual Sales (using n-1 and n)
5 What is the sum of all Square Feet observations?
6 Create a new column of Annual Sales that are sorted from high to low
7 What is the range of Annual Sales?
8 What is the average number of Square Feet (compute the mean)?
9 Create a scatter diagram of Annual Sales (on the vertical) and Square Feet (on the Horizontal)
10 Provide both the intercept and slope of a simple linear regression model using this data
11 Is there a significant relationship between Annual Sales and Square Feet? How do you determine if there is a significant relationship?
Show all numerical results with four digits to the right of the decimal