Quantitative Business Analysis Question

Aug 26th, 2014
FratBro23
Category:
Business & Finance
Price: $80 USD

Question description

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. The opening weekend gross sales, the total gross sales, the number of theaters the movie was shown in, and the number of weeks the motion picture was open are common variables used to measure the success of a motion picture. Data collected for a sample of 100 motion pictures produced in 20XX are contained in the file named Movies. Use all 100 data points.

Managerial Report

Prepare a report (see below) using the numerical methods of descriptive statistics presented in this module to learn how the variables contribute to the success of a motion picture. Be sure to include the following three (3) items in your report.

  1. Descriptive statistics (5-number summary, mean, mode, range, and standard deviation) for each of the four variables along with an explanation of what the descriptive statistics tell us about the motion picture industry.
  2. What motion pictures, if any, should be considered high-performance outliers in each of the four variables? If there are any outliers in any category, please list them and state for which category they are an outlier. Describe which method you used to determine if there were or not.
  3. Descriptive statistics (correlation coefficient) showing the relationship between total gross sales and each of the other three variables. Please provide an explanation of the relationships.movies.xlsx

Be sure that your report contains the following:

  • A title page
  • An introduction
  • A body of the paper that answers the questions posed in the problem and calculations and graphs associated with this problem.
  • A conclusion paragraph that addresses your findings and what you have determined from the data and your analysis. 

Be sure to submit your Excel file as well.


Tutor Answer

(Top Tutor) Daniel C.
(997)
School: UCLA
PREMIUM TUTOR

Studypool has helped 1,244,100 students

8 Reviews


Summary
Quality
Communication
On Time
Value
ddg82
Dec 3rd, 2016
" Thanks, good work "
kenmwao2
Nov 22nd, 2016
" Solid work, thanks. "
tinytim47
Nov 20th, 2016
" Wow this is really good.... didn't expect it. Sweet!!!! "
jestin7
Nov 11th, 2016
" This tutor is great! "
lilmoe415
Oct 28th, 2016
" Thank you, Thank you, for top quality work, this is your guy!! "
dontuwannaknow
Oct 6th, 2016
" Excellent work as always thanks so much "
thargrow
Sep 27th, 2016
" Very Satisfied. "
SjSurvivor143
Sep 22nd, 2016
" Thanks for the help. "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1824 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors