Correlation - Hamburger Meal (X-XBar) 2 (Y-YBar) 2 n-1 S X...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Movie Ticket (X-XBar)(Y-YBar) 5.99 32.66 1.0221 157.1764 12.6749 7.62 28.41 6.9749 68.6744 21.8860 5.75 20 0.5944 0.0151 -0.0948 4.45 20.71 0.2798 0.3446 -0.3105 4.99 18 0.0001 4.5071 -0.0234 5.29 19.5 0.0967 0.3881 -0.1938 4.39 18 0.3469 4.5071 1.2504 3.7 16 1.6358 16.9991 5.2733 4.62 18.05 0.1289 4.2973 0.7442 2.99 9.9 3.9561 104.5097 20.3335 Sums: 15.04 361.42 61.5399 : Calculations XBar 4.98 YBar 20.12 9 Covariance 6.83777 1.2925 6.3370 r 0.8348
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Hamburger Meal (X-XBar) 2 (Y-YBar) 2 n-1 S X S Y When modifying this sheet for other data sets, adjust the table area by first selecting row 5 and then inserting or deleting rows as is necessary. Changing the table in this manner will allow Excel to automatically update the formulas in the Calculations section....
View Full Document

Ask a homework question - tutors are online