Refer to the Excel file Lab #1

Excel Lab #1 Link: https://1drv.ms/x/s!Ag6WjAqSgm6igTYp1NZX7WuQvtqM

Make sure to use complete sentences.

Lab #1 - Tabular and Graphical Displays

Objectives: At the end of this lab, you will be able to:

• Find descriptive statistics using Excel and SPSS
• Identify appropriate ways to summarize data
• Explore relationships using crosstabulation/contingency tables
• Interpret the results in the context of the problem

Data Set: 2011 Movies

The motion picture industry is a competitive business. More than 50 studios produce a total of 300 to 400 new motion pictures each year, and the financial success of each motion picture varies considerably. Data collected for the top 100 motion pictures produced in 2011 are listed in the Lab #1 Excel file.

Description of the variables

Motion picture: The name of the movie

Opening Gross Sales ($): the opening weekend gross sales in millions of dollars

Total Gross Sales ($): The total gross sales in millions of dollars

Number of Theaters: The number of theaters the movie was shown in

Weeks in Release: the number of weeks the movie was released

Exercise 1. Use graphical methods and descriptive statistics to explore the variables to learn how the variables measure the success of the motion picture business.

1. Identify which of the four quantitative variables would be appropriate to summarize a) using grouped frequency distributions and b) using ungrouped frequency distributions. Explain.
2. Construct frequency distributions and graphs for each of the four quantitative variables.
3. Use descriptive statistics to summarize opening gross sales, the total gross sales, the number of theaters, and weeks in release. What conclusions can you draw about the opening gross sales, the total gross sales, the number of theaters, and the number of weeks the movie was released?
4. Construct a cross-tabulation table to explore the relationship between the total gross sales and the opening weekend. Discuss the relationship between the total gross sales and the opening weekend.
5. Use a cross-tabulation table to explore the relationship between the total gross sales and another variable. Discuss the relationship between the total gross sales and the variable you select.