Reference no: EM13858360
You have recently taken on work as the quantitative business analyst for a company that holds the DVD distribution rights for movies. The company wants to estimate the sales revenue for each DVD movie it distributes. Currently, the company tends to follow some adhoc guidelines to form these estimates. However, they have recently acquired some data on DVD sales, and have hired you to help analyse it and assess or inform/improve their DVD revenue estimation methods. The data are in the file "Movie.xls", available on the BUSS1020 Blackboard site. You are required to present and explain all your assumptions and discuss whether they could be true, or not, in each case, in answering each of the questions below
The company has always estimated DVD revenue differently, based on whether the box office revenue was in excess of $100 million, or not. In fact the company usually estimates that DVD revenue will be higher by $25 million when the box office revenue is in excess of $100 million.
i. Fully investigate the hypothesis that DVD revenues are larger on average when the box office revenue is in excess of $100 million. State all required assumptions, indicate your chosen level of significance (and why you chose it) and give a plain-English business context conclusion.
ii. Test the dealership's hypothesis that $25 million should be added to the estimated DVD revenue, when the box office revenue is in excess of $100 million. Does the data support that hypothesis?
Attachment:- Movie.xlsx
|
A fitness centre runs a promotion
: A fitness centre runs a promotion in which it invites 'participants to claim a free fully supervised two-hour workout'. Mary turns up to the centre in order to take advantage of the offer, but is told she must enter a six-month membership contract be..
|
|
What is the output of this code sequence
: What is the output of this code sequence
|
|
What are the advantages and disadvantages of the recently
: What are the advantages and disadvantages of the recently increased ability to limit one's liability when operating a business? Do the advantages outweigh the disadvantages? Should certain kinds of businesses not be permitted to operate with limited ..
|
|
In what ways does behaviorist theory support this philosophy
: The scientific or positivist philosophy of education argues that knowledge can be discovered and constructed scientifically. In what ways does behaviorist theory support this philosophy
|
|
Quantitative business analyst
: You have recently taken on work as the quantitative business analyst for a company that holds the DVD distribution rights for movies. The company wants to estimate the sales revenue for each DVD movie it distributes
|
|
Pamela and her friends, who are residents ofcalifornia
: Pamela and her friends, who are residents ofCalifornia decided to go to Vegas (Nevada) and celebrate her 25th Birthday. They checked into hotel WIN WIN :-) and after sight seeing they decided to go gamble. Pamela was sitting underneath a big chandeli..
|
|
Analyzing what to improve and how to improve
: If your problem involves process design/improvement, analysis of the problem may include describing the process in details using actual information and analyzing what to improve and how to improve. If actual information is not available, you shoul..
|
|
Limited attention span creates a constraint based upon
: Limited attention span creates a constraint based upon
|
|
Rashi is a student at state university
: Rashi is a student at State University. In need of funds to pay for tuition and books, Rashi asks Tiempo Loans, Inc., fora short-term loan. The lender agrees to make a loan if Rashi will have someone who is financially responsible guaranteethe loan p..
|