For Eng.Kelvin Only!!! #2
Assignment for quantitative business analysy
Managerial Report
Prepare a report (see below) using the numerical methods of descriptive statistics presented in this module to learn how each of the variables contributes to the success of a motion picture. Be sure to include the following three (3) items in your report.
1 Descriptive statistics (mean, median, 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 Use the z-score to determine which movies, 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 make your determination.
3 Descriptive statistics (correlation coefficient) showing the relationship between total gross sales and each of the other three variables. Evaluate the relationships between total gross sales and each of the other three variables. Use tables, charts, graphs, or visual dashboards to support your conclusions.
Write a report that adheres to the Written Assignment Requirements under the heading “Expectations for CSU-Global Written Assignments” found in the CSU-Global Guide to Writing and APA Requirements. As with all written assignments at CSU-Global, you should have in-text citations and a reference page. An example paper is provided in the MTH410 Guide to Writing with Statistics, linked at the bottom of the page.
Your report must contain the following:
· A title page in APA style.
· An introduction that summarizes the problem.
· The body of the paper should answer the questions posed in the problem by communicating the results of your analysis. Include results of calculations, as well as charts and graphs, where appropriate.
· A conclusion paragraph that addresses your findings and what you have determined from the data and your analysis.
Submit your Excel file in addition to your report.