Asked May 20, 2019

Expert Answer

Step 1


It is given that “Budget” as x variable and significance level of α=0.05.

The regression equation is y-cap=β0+ β1x, where, β0 is intercept and β1 is the slope of regression.

Computation of regression equation:

Step-by-step EXCEL procedure to find the regression equation is as follows.

  • Go to Data -> Data Analysis.
  • Select “Regression” from Analysis Tools and click Ok.
  • Select Y data in Input Y Range and select X data in Input X Range.
  • Click Ok.

The output is as follows.

Step 2

Coefficients and Regression equation:

The coefficient of intercept is 21.7958 and the coefficient of x variable is 1.2434.

The regression equation is y-hat=21.8+1.2x.

Step 3

Calculation of predicted amount that a movie will gross its budget of $100 million:

The predicted amount that a movie will gross its budget of...


Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in



Related Statistics Q&A

Find answers to questions asked by student like you
Show more Q&A

Q: An advertising executive wants to determine if a new billboard placed in a city caused sales of thei...

A: Given that we need to test to determine if a new billboard played in a city caused sales of their pr...


Q: Use this for 11-12: A student club consists of 10 girls and 10 guys. A committee of 8 is to be selec...

A: Combination Rule:A combination is a selection of all or part of a set of objects, without regard to ...


Q: Arianna Estefan manages Salmon Falls Park, which has two flagship roller coasters, the Flyer and the...

A: Given Null hypothesis : H0 : µ1 = µ2Alternate hypothesis : Ha : µ1 < µ2,   where µ1 is mean numbe...


Q: Let A and B be two events with P(A) = 0.71 and P(B) = 0.44. What is the largest possible value of P(...

A: In this question, we have the value of P(A) = 0.71 and P(B) = 0.44 and we have to find the maximum v...


Q: In a fishing logde brochure, the lodge advertises that 75% of its guest catch northern pike over 20 ...

A: The provided information are:


Q: Use the normal approximation to the binominal to approximate the probabilities. A gardener buys a pa...

A: Normal approximation to the binomial:If a random variable X ~ B(n, p) in which n is large and p is c...


Q: We use the form  ŷ = a + bx  for the least-squares line. In some computer printouts, the least-squar...

A: Hello. Since you have posted multiple questions and not specified which question needs to be solved,...


Q: If a given line has a negative slope, then what is the sign of the slope of the line that is perpend...

A: Relationship between slopes of two perpendicular straight lines:The slopes of two lines, which are p...


Q: A politician recently made the claim that 47% of taxpayers from a certain region do not pay any inco...

A: The aim is to identify the null and alternative hypotheses for testing the claim.