代做data程序、代写c/c++，Python编程
Name(s): _______Vickie_____________ Date: _________________
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
Directions: Refer to the Excel file Lab #1 to complete the following tasks. All results and
explanations need to be reported within this Word document after each question. Make sure to
use complete sentences when explaining your results. Your results should be formatted and
edited.
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 [OGS] ($): the opening weekend gross sales in millions of dollars
Total Gross Sales [TGS] ($): The total gross sales in millions of dollars
Number of Theaters [NT]: The number of theaters the movie was shown in
Weeks in Release [WR]: the number of weeks the movie was released
Exercise 1. Use graphical methods and descriptive statistics to explore all the variables to learn
how the variables measure the success of the motion picture business.
A. Identify which of the four quantitative variables (OGS, TGS, NT, and WR) would be
appropriate to summarize a) using grouped frequency distributions and b) using
ungrouped frequency distributions. Explain.
Grouped: OGS, TGS
Ungrouped: WR, NT
B. Construct frequency distributions and graphs for each of the four quantitative variables
(OGS, TGS, NT, and WR).
C. 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 weeks
the movie was released?
Opening Gross Sales: With a sample size of 100, OGS averaged approximately $27.5M
with a standard deviation of $26.5M. These two values alone suggests that OGS is
extremely skewed to the right, which is also highlighted with a median of $19M
compared to the mean (average) of $27.5M. With a range of $169.12M compared to the
maximum of $169.19M further indicated a wide spread in the data and the potential for
outliers.
Total Gross Sales: Using the same sample size, the TGS is higher than the OGS. The
average TGS for the 100 movies is $90.4M, with a median of $72.4M and a standard
deviation of $68.1M. While not as skewed as OGS the TGS is skewed to the right. Again, the range is $351.9M with a maximum of $381M, very likely to have outliers in the data
set.
Weeks in Release: With the sample size of 100 movies, the mean and median are
approximately the same (mean = 14.58 weeks and median = 14.5 weeks) with a standard
deviation of 5 weeks. These statistics indicate the distribution is approximately normal.
However, with a range of 37 weeks with the maximum number of weeks at 43, there
should be concerns about potential outliers.
Number of Theaters: With the sample of 100 movie theaters, we find the mean to be 3114
movie theaters and the median to be 3102 movie theaters. Based on these values the
distribution appears slightly skewed right, however, the graph indicates the distribution is
skewed left. Taking a look at the graph of Number of Theaters as an ungrouped
distribution we are better able to see the distribution is approximately normal with some
potential outliers to the left, which accounts for the distribution appearing more skewed
to the left.
D. 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.
Based on the results of the crosstabulation, the TGS sales increased as the OGS increased. The
better a movie did during its opening is an indicator of expected total sales.
E. 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.
Lower Total Gross Sales (≤ 76.06 million):
The majority of movies with lower gross sales (≤ $76.06 million) tend to be shown in fewer
theaters, with 21 movies being released in theaters numbering between 2801-3050. However,
this group also spans a wide range of theater counts, showing that movies with lower sales
can be distributed widely, but with little impact on gross sales.
Mid-Range Gross Sales (76.07 million - 216.06 million):
Movies with moderate total gross sales between $76.07 and $216.06 million tend to be
distributed across a more moderate number of theaters. For example, in the $76.07-$111.06
million range, 6 movies were shown in 2801-3050 theaters, and the numbers are smaller
across other theater count ranges.
It suggests a slight increase in total gross sales as the number of theaters increases, but
there’s no clear-cut, direct linear relationship visible at this point.
High Total Gross Sales ($356.07+ million):
Interestingly, the movie(s) with the highest gross sales (greater than $356.07 million) are
shown in a significant number of theaters (4051–4300), indicating a clear relationship
between high box office performance and wide distribution.
The concentration of movies with gross sales above $321.07 million tends to occur in theater
counts above 4051, reinforcing the idea that wider distribution contributes to higher total
sales.
Overall Relationship:
There appears to be a positive relationship between the Number of Theaters (NT) and Total
Gross Sales (TGS). Movies that are distributed in more theaters generally tend to have higher
gross sales.
However, the relationship is not perfectly linear, as there are some movies with fewer
theaters (like those ≤ 2300 theaters) that have respectable gross sales. Conclusion:
The data suggest that wider distribution (more theaters) tends to correspond with higher gross
sales, particularly at the higher end of the sales spectrum. However, other factors, such as the
quality, marketing, and audience appeal of the movie, likely influence total gross sales as
well.