Ticket Sales Total Revenues Analysis

Do not change the location of the data/information in the file (except in the “Data Sandbox” worksheet). You will only be adding to it, not changing what you have been given.

please leave cells B1,2, and 5 empty

Data Worksheet (enter the data; do not make changes to this worksheet)

1. Enter the Ticket sales revenue data for each university by sport in columns C through E as described in Lecture20-03. Do not make any changes to this worksheet other than entering the data as instructed. [25 points]

2. If the sport is listed on the .pdf file, but the corresponding cell is blank on the .pdf file, leave that cell blank in the spreadsheet for that sport.

3. If the sport is listed, and there is a revenue number for one group, type that in the spreadsheet, but if there is not a number for the other group(s), leave that cell(s) blank in the spreadsheet.

4. If the data is missing in the .pdf file, make a note of that on the “Student & Exam Information” worksheet.

5. For the Subtotal, Revenue not related, and Total revenue rows (the last three rows for each university), include a zero even if it is blank on the .pdf file.

Data Sandbox Worksheet After you have collected all the ticket sales data for the universities you have been assigned, copy and paste|values all the data into this worksheet. That way, if you make any mistakes, the original data is preserved and you can re-copy and paste|values the data back to this worksheet. For the following three worksheets, you will need to sort the data, so this is where you must do that.

Total Ticket Sales Revenue Data Worksheet

1. In your Microsoft Excel file, calculate the average of total ticket sales revenue for men’s programs in cell B2; calculate the median of total ticket sales revenue for men’s programs in cell B3; and calculate the standard deviation of total ticket sales revenue for men’s programs in cell B4. Calculate the average of total ticket sales revenue for women’s programs in cell C2; calculate the median of total ticket sales revenue for women’s programs in cell C3; and calculate the standard deviation of total ticket sales revenue for women’s programs in cell C4. Calculate a Welch’s t-test for men’s and women’s total ticket sales revenue in cell B6; Calculate a Welch’s t-test for men’s and not allocated total ticket sales revenue in cell B7; Calculate a Welch’s t-test for women’s and not allocated total ticket sales revenue in cell B8. Save your Excel file now. [If you forget how to make these calculations in Excel, see Lecture08.] [15 points]

2 | Page Basketball Ticket Sales Worksheet (men’s and women’s)

1. In your Microsoft Excel file, calculate the average of ticket sales revenue for men’s basketball in cell B2; calculate the median of ticket sales revenue for men’s basketball in cell B3; and calculate the standard deviation of ticket sales revenue for men’s basketball in cell B4. Calculate the average of ticket sales revenue for women’s basketball in cell C2; calculate the median of ticket sales revenue for women’s basketball in cell C3; and calculate the standard deviation of ticket sales revenue for women’s basketball in cell C4. Calculate a Welch’s t-test for men’s and women’s ticket sales revenue in cell B6. Save your Excel file now. [If you forget how to make these calculations in Excel, see Lecture08.] [15 points]

Other Sport Ticket Sales Worksheet (either men’s or women’s sport)

1. Now choose the sport with the next highest number of observations [rows of data] for either a men’s or women’s sport (it could be the same number of observations as for basketball), but only choose the next highest for one sport’s gender. In your Microsoft Excel file, calculate the average of ticket sales revenue for other sport (either men’s or women’s – not both) in cell B2; calculate the median of ticket sales revenue for other sport in cell B3; and calculate the standard deviation of ticket sales revenue for other sport in cell B4. Calculate a Welch’s t-test for men’s and not allocated TOTAL ticket sales revenue in cell B6 OR Calculate a Welch’s t-test for women’s and not allocated TOTAL ticket sales revenue in cell B7. Save your Excel file now. [If you forget how to make these calculations in Excel, see Lecture08.] [15 points]

In your Microsoft Word file, based on the data you have analyzed for these universities, clearly and completely: