For the questions below, use the most efficient Excel formula or procedure to find your answer. Calculations by hand (or calculator) should only be used to check your
answers. Show relevant Excel output and/or formulas and results. For this assignment you will be using the Movie Theatre Attendance.xlsx file from BlackBoard.
Immediately save this file to your H: drive or memory stick. For purposes of this assignment consider these to be sample data.
Please complete the following tasks:
Question 6 of Movie Theatre Attendance.xlsx asks college students (who go to the movie theatre) “how much further [they] would drive beyond the cinema nearest to
[them] to see a movie at a ‘big screen’ theatre?” Recode the variable: 0:0, 1:5, 2:17.5, 3:37, 4:62. Eliminate blanks. Is there a significant difference between
variances of responses for females compared to males? [Hint: you can either sort the database according to gender or (for a bonus mark) you can use a pivot table to
find the counts and variances.] Use an F test (on pages A-2 and A-3 of your Class Notes book). Show your hypotheses, calculation of F* using Excel, and either the
critical F value(s) or p-value, calculated by Excel, and decision. Describe the difference if one exists. [9]
In this task you will use ANOVA to analyze the relationship between Q14 (AGE) and Q2 (“Indicate how important you consider going to the movies at a movie theatre,
relative to other leisure activities.”) Recode the Age variable to classmarks: 1:17.5, 2:19.5, 3:22, 4:25, 5:28. Use ANOVA – single factor in Excel’s Data Analysis
ToolPak to test whether there is a relationship between the two variables. Show your hypotheses, ANOVA output, and decision – referring to numbers in the ANOVA output.
If there is a relationship, describe it in non-statistical language, with a visual analysis of the means. Then, use Excel to create formulas for a Multiple Means
(Fishers) comparison for the two means that differ the most. Show the Excel formulas that are used to do the comparison, using constants (rather than cell references)
from the ANOVA output as well as the Excel T… function. (Do not use the output from the ANOVA – F14 file.) How does the Fishers test support your conclusion? (Note:
Consider the categories of Q2 to be your treatments. In a future unit we will learn of a better way of handling this type of problem.) [13]
Redo the question above (Q14 vs. Q2) using a Kruskal-Wallis test. Use the ANOVA – F14.xlsx template found on Blackboard to do your calculations. Show your modified
hypotheses, results from the output and decision. Do your results match those from the question above? Why or why not? (Support with appropriate output.) Describe the
relationship, if one exists, in words that a non-statistician would understand. (Note: it is not necessary to do a Fishers’ comparison.) [11]
Test to see if there is a relationship between Q11 (ethnic background) Q7b (importance of the Internet for searching information about movies) Eliminate blanks. Show
your hypotheses, appropriate output, decision based on the output. Describe the difference, if one exists. [Hint: Use the ANOVA-F14.xlsx template.] [9]
Question 6 of Movie Theatre Attendance.xlsx asks college students (who go to the movie theatre) “how much further [they] would drive beyond the cinema nearest to
[them] to see a movie at a ‘big screen’ theatre?” Recode the variable: 0:0, 1:5, 2:17.5, 3:37, 4:62. Exclude blanks. Is there a significant difference between means of
responses for females compared to males? [Hint: Do question #1 first.] Show your hypotheses, appropriate output for this two-sample hypothesis test from the Data
Analysis Toolpak, p-value from the output, and decision. Describe the difference, if one exists. [8]
