To carry out an assignment using Excel and box office figures, cut and paste the box office charts from The Numbers website into Excel. It is best to work with the weekly box office figures. Compare and contrast the results from several consecutive weeks of the charts, focusing on statistics such as average box office, skewness of the chart each week. Experiment with different statistical tests. Part of the grade will be based on your ability to use the software effectively to identify trends and patterns in the data using simple statistical tests found on Excel. Organize your assignment according to the IMRaD model: Introduction, Method, Results, and Discussion (use these four headings). Introduction: Specify the parameters of your data, including: Object of analysis Method: Identify the box office variables (types of data). Results: Present your results in tables, charts, written description, etc. Discussion: Examine the results and identify what you discovered by carrying out this analysis. Discover is an important term you are generating new information, not simply summarising what already exists. Word count: 2000 words. Include diagrams and tables (but make sure they are useful they generate insights about the box office charts you have analysed and make sure you interpret each one. To avoid confusion, label each one Table 1, Table 2, etc.).
The post assignment using Excel and box office figures appeared first on My Assignment Online.
