Make a histogram and obtain descriptive statistics, Strategic Management

Assignment Help:

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.


Related Discussions:- Make a histogram and obtain descriptive statistics

How might a company sustain and win a price war, ? A) By including a lower ...

? A) By including a lower cost structure ? B) By cross-subsidizing one business from another ? C) By including "deeper pockets" to fund short to medium term losses

Linking strategic organizational, Linking Strategic Organizational Initiati...

Linking Strategic Organizational Initiatives to Purpose, Mission, and Vision Select an existing business that is entering into a new or emerging market for that company. You may

Management, What can middle managers do to moderate the distortions introdu...

What can middle managers do to moderate the distortions introduced by such biases?

Management and Strategy, #quesWhat features of Johnson & Johnson''s "Our Cr...

#quesWhat features of Johnson & Johnson''s "Our Credo" made it so effective in guiding J&J''s response to the Tylenol tampering crisis? Where was J&J''s "Our Credo" in the run-up t

Statistical procedure for management, A highly perishable drug spoils after...

A highly perishable drug spoils after three days.  That is, a fresh unit on day t may be used on day t, day t+1, and day t+2, but must be disposed of at the end of day t+2. Each

Controlling subsidiaries, Controlling subsidiaries Mission stateme...

Controlling subsidiaries Mission statement, goals and objectives. Performance measurement systems e.g. financial ratios and multidimensional frameworks. Systems

Consolidation is concerned with, Protecting and strengthening the organizat...

Protecting and strengthening the organization's position in its present markets by its current products

Professional strategies to increase personal networking, Cham Stores is one...

Cham Stores is one of the biggest private sector employer in the Syria. The company has more than 2000 employees in Syria, Emirates and London. In Syria, Cham Stores range from sma

Feed-forward control - prevention rather than cure, Q. Feed-forward control...

Q. Feed-forward control - prevention rather than cure? Feed-forward control would be a system that in a pre-emptive way, reacts to changes in its environment, normally to maint

Management strategic planning, You are an asset manager for a large public ...

You are an asset manager for a large public utility organisation. The organisation has a range of assets, ranging from major distributors to minor assets directly serving users (fo

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd