Need stat help!

ballmode

Lifer
Aug 17, 2005
10,246
2
0
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
 

Hyudra

Senior member
Jan 16, 2001
897
0
0
dude, just dump that all into Excel and use the VBA pack to get the ans.

=stdev
=mean or it is =avg?
=median or is there none for this, lol

11. - look at the t-stat or z-stat?
 

bubbadu

Diamond Member
Aug 30, 2001
3,551
0
0
Not sure why I would do your homework for you, but I enjoy stats and do the easy ones.

4. Use regular std deviation equation, once for n and once for n-1
5. JUST ADD UP SQUARE FEET.
6. NEW COLUMUN SORT (I would do this but my minitab lincese has expired)
7. Range = highest ob - lower (duh)
8. Compute mean, real easy
9. Minitab FTW.
10. Do SLR, use graph
11. Based on R(squared) judge level of relationship.
 

ballmode

Lifer
Aug 17, 2005
10,246
2
0
I have no clue how to use minitab or excel. Can anybody PM me or post here on how to get these "formulas" into excel/minitab?

Thing is, I'm not in a stat class, but the teachers gave this to us to be quizzed on before we go into the business college. Why? I have no clue.