# Covariance - Movie Ticket (X-XBar)(Y-YBar) 5.99 32.66...

This preview shows pages 1–2. Sign up to view the full content.

Covariance Analysis Movie Ticket (X-XBar)(Y-YBar) 5.99 32.66 12.67491 7.62 28.41 21.88597 5.75 20 -0.09483 4.45 20.71 -0.31052 4.99 18 -0.02335 5.29 19.5 -0.19375 4.39 18 1.25045 3.7 16 5.27332 4.62 18.05 0.74421 2.99 9.9 20.33355 Calculations XBar 4.98 YBar 20.12 9 Sum 61.53993 Covariance 6.83777 Hamburger Meal n -1 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.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Covariance Analysis
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Movie Ticket (X-XBar)(Y-YBar) 5.99 32.66 =(A4-\$C\$16)*(B4-\$C\$17) 7.62 28.41 =(A5-\$C\$16)*(B5-\$C\$17) 5.75 20 =(A6-\$C\$16)*(B6-\$C\$17) 4.45 20.71 =(A7-\$C\$16)*(B7-\$C\$17) 4.99 18 =(A8-\$C\$16)*(B8-\$C\$17) 5.29 19.5 =(A9-\$C\$16)*(B9-\$C\$17) 4.39 18 =(A10-\$C\$16)*(B10-\$C\$17) 3.7 16 59.20000 4.62 18.05 =(A12-\$C\$16)*(B12-\$C\$17) 2.99 9.9 =(A13-\$C\$16)*(B13-\$C\$17) Calculations XBar =AVERAGE(A4:A13) YBar =AVERAGE(B4:B13) =COUNT(A4:A13)-1 Sum =SUM(C4:C13) Covariance =C19/C18 Hamburger Meal n-1...
View Full Document

## This note was uploaded on 02/27/2010 for the course ECON 210 taught by Professor Dk during the Spring '09 term at Bridgewater State University.

### Page1 / 2

Covariance - Movie Ticket (X-XBar)(Y-YBar) 5.99 32.66...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online