Make a histogram and obtain descriptive statistics, Strategic Management

For this question you will analyse box office receipt data for two movies: Harry Potter 1: Sorcerer's

Stone and Pirates of the Caribbean 1: Curse of the Black Pearl.

Go to the portal and download background data.xls

Select the worksheets HP Weekend and Pirate Weekend

 

For your analysis of each movie, you will only need the Date and Per Theater box office receipts; you may delete the remaining columns.

(a) Make a histogram and obtain Descriptive Statistics, including Quartile 1 and

Quartile 3, for weekend per theatre box office receipts each of the movies. Include output of your data, histograms and Descriptive Statistics in your assignment submission.

EXCEL Instructions:

Add your name and ID to the column names for weekend per theatre receipts (e.g. Pirates 1

Receipts should become 'Pirates 1 Receipts FamilyName, GivenName, ID').

Create another column called Bin with numbers from 1000 to 10000 in steps of 1000 (i.e. 1000, 2000, 3000 and so on up to 10000). Histograms may be obtained using the Data Analysis tool in Excel, but some formatting is required. Please make sure that the title of your histogram ends with your ID (e.g. Harry Potter 1 weekend per theatre receipts 599999).

Descriptive Statistics may also be obtained using the Data Analysis tool.

You will need to manually calculate the two quartiles. Please explain the method used.

(b) Describe the shape (symmetry, modality and outliers) of each distribution.

Instructions for identifying outliers:

Whether an observation is an outlier is a matter of judgement. One rule commonly used for identifying outliers is the so-called 1.5 × IQR rule. An observation is suspected to be an outlier if it is more than 1.5 × IQR below the first quartile Q1 or above the third quartile Q3.

Apply this rule to Harry Potter 1 weekend per theatre receipts and Pirates 1 weekend per theatre receipts. Identify suspected outliers (if any) by their date and amount.

(c) Nominate appropriate summary measures for the distribution of Harry Potter 1 weekend per theatre receipts, and for the distribution of Pirates 1 weekend per theatre receipts. Give reason(s) for your choice. For each distribution, give and interpret the values of the summary measures you have chosen.

(d) Write a short paragraph discussing the similarities and differences between weekend per theatre receipts for the two movies. Be sure to consider the measures of central tendency and dispersion, as well as the shape of the two distributions.

Posted Date: 2/25/2013 4:19:13 AM | Location : United States







Related Discussions:- Make a histogram and obtain descriptive statistics, Assignment Help, Ask Question on Make a histogram and obtain descriptive statistics, Get Answer, Expert's Help, Make a histogram and obtain descriptive statistics Discussions

Write discussion on Make a histogram and obtain descriptive statistics
Your posts are moderated
Related Questions
Q. What is Uncontrollable costs ? Uncontrollable costs General apportioned fixed overhead e.g. group overhead allocated or apportioned to divisions, which would not b

Advantages and disadvantages 1. Advantages There are some benefits that Aldi can get from short term objectives such as allow development or small format supermarkets in edg

The beyond budgeting approach may include the following: Use of rolling budgets concentrating on cash forecasts and not cost control. Budgets revised more frequently

The objective of the term project is to demonstrate your understanding and ability to apply the body of knowledge covered in this course. The goal will be on identifying communicat

Benefits of using balanced scorecard (BSC) - BSC encourages a long-term view of improving performance through time. - BSC considers both non-financial as well as financial m

Cookie company is open for all day and night, 24 hrs. Enough demand exists to keepthe cookie company busy 24 hrs. Assume you have: (i) One oven which can accommodate one tray

The group consolidated financial results would normally be effected, if an internal buyer uses their autonomy and makes a decision to buy outside the group, rather than buy interna

Q. Process to implement balanced scorecard? 1. A clear vision of introduction of a BSC communicated and demonstration which senior management are committed to the idea. 2. E

a)  Make measures for evaluating a strategic plan. b)  Make a schedule for executing a strategy plan in an organization. c)   Make appropriate dissemination process to gain comm

Experienced staff of the organisation contributes in the business expansion of the company. Additionally, the company also provides intensive immersion program for its frontline cr