Purchase Solution

Statistics: Box Office Gross and Video Units Sold

Not what you're looking for?

Ask Custom Question

Consider the data below, where data are available for 30 movies that indicate the box office gross (in millions of dollars) and the number of units sold (in thousands) of home videos. Use EXCEL/PHStat to produce the print-out to answer the problems 5 to 9.

1. Find the SSE:
a) 171499
b) 64154
c) 235654

2. Compute the standard error of estimate:
a) 47.87
b) 51.29
c) 10.32

3. Compute r^2
a) .708
b) .728
c) .853

4. Compute r:
a) .618
b) .728
c) .853

5. If the box office gross is increased by 1 million dollars, how much do you expect the increase of the number of home video units sold?
a) 79,653 units
b) 4,333 units
c) 43,331 units

Gross Videos
$million (x1000)
1.10 57.18
1.13 26.17
1.18 92.79
1.25 61.60
1.44 46.50
1.53 85.06
1.53 103.52
1.69 30.88
1.74 49.29
1.77 24.14
2.42 115.31
5.34 87.04
5.70 128.45
6.43 126.64
8.59 107.28
9.36 190.80
9.89 121.57
12.66 183.30
15.35 204.72
17.55 112.47
17.91 162.95
18.25 109.20
23.13 280.79
27.62 229.51
37.09 277.68
40.73 226.73
45.55 365.14
46.62 218.64
54.70 286.31
58.51 254.58.

Purchase this Solution
Solution Summary

The solution discusses the box office gross and video units sold.

Solution Preview

See the attached file.

Regression Statistics
Multiple R 0.853088695
R Square 0.727760321
Adjusted R Square 0.718037476
Standard Error 47.8667885
Observations 30

ANOVA
df SS MS F ...

Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

View More Free Quizzes
Related BrainMass Solutions

  • Lynam Company

    Prepare flexible budgets that show variable costs per unit, fixed costs, and 3 different flexible budgets for sale volumes of 6,000, 7,000 and 8,000 units.

  • Relevant Costing, Buy or manufacture, Variable Costing

    ______________________ Production and cost data for the two years are given below: Year 1 Year 2 Units produced 25,000 25,000 Units sold 20,000 30,000 ________________________________________ Requirement 1: Prepare a variable costing income

  • Preparing a Budgeted Income Statement

    Regular units are manufactured to meet marketing projections, and specialized units are made after an order is received. Maintaining the video-conferencing equipment is an important area of customer satisfaction.

  • The Plane ride to Profit

    Units sold 10,000 Selling Expenses $167,000 Beginning Inventory $200,000 Ending Inventory $250,000 Unit Price $ 62.50 Office Supplies $ 5,000 Utility Expense $ 7,000 Insurance Expense $ 10,000 Income Taxes $ 28,000 Employee

  • Movie Accounting: Forrest Gump

    Films are typically distributed to theaters under an agreement that splits the gross box office receipts approximately 50/50 between the theater and the movie studio.

  • Multiple Choice

    The LIFO inventory method assumes that the cost of the latest units purchased are a. the last to be allocated to cost of goods sold. b the first to be allocated to ending inventory. c. the first to be allocated to cost of goods sold.

  • Various accounting Problems

    Since the unit cost is rising, high cost units are sold first, increasing the cost of goods sold Jun-01 200 5 1000 Jun-12 300 6 1800 Jun-23 500 7 3500 Total 1000 6300 Average Cost 6.3 In average cost, all the units are added together and

  • Flexible budgets by identifying variable and fixed components

    Prepare flexible budgets that show variable costs per unit, fixed costs, and three different flexible budgets for sales volumes of 6,000, 7,000, and 8,000 units Sales (7,000 units) $2,800.000 Cost of goods sold: Direct materials $280,000 Direct

  • Potential Gross Income of Rental Units

    Potential gross income=$10,000 per month The potential gross income is calculated for a group of office rental units given several metrics.

View More Related Solutions