Question

In: Statistics and Probability

  The following table represents the internet advertising revenue (in billions).      (x represents the time in years...

  1.   The following table represents the internet advertising revenue (in billions).

     (x represents the time in years since 2007) Round function values to nearest hundredth.

Year 2007 2008 2009 2010 2011 2012 2013 2014

Internet Advertising Revenue (in billions) 21.2 23.4 22.7 25.8 28.5 32.6 36 40.5

a) Create a table of the r squared values together with each of your best fit curves (round to nearest thousandth).

b) Copy the best of the best fit functions here. Explain how you picked this function.

c) Use your best function to estimate the Internet Advertising Revenue this year.

Solutions

Expert Solution

This is the regression output from excel in tabular form

enter your data ---> go to Data Analysis Tab ---> select regression--->select your independent and dependent variables---->tick the box of labels---> select your output range that's it you will get the above output.

R-squared value is the square of the Multiple R value which is also called correlation coefficient. Below I am providing calculation for correlation if you want to know the procedure as excel just produce results directly.

Here X is year and Y is revenue.

sp r=0.9696 is correlation (multiple R) .

Now you can see another table where you can see coefficients for intercept and year how to calculate those? again I am providing you calculations below-

You can see the intercept coefficient -5788.07 matches with our calculation and also the slope coefficient of 2.744 matches with our calculation so that's how you can get these manually.

B) Your best fit function is y= -5488.07+2.744.x as you can also see above (this is also known as best fit regression equation). Explanation how we picked this?

the following equation is estimated by the method of least squares which ensures that the estimates we get for intercept and slope are best.

C) Revenue this year(2020) = -5488.07+ 2.744*2020 = 54.81 (just put 2020 in place of x)

I hope this helps you.

Thanks


Related Solutions

The following table shows a company's annual revenue (in billions of dollars) for 2009 to 2014....
The following table shows a company's annual revenue (in billions of dollars) for 2009 to 2014. Year Period (t) Revenue ($ billions) 2009 1 23.6 2010 2 29.2 2011 3 37.8 2012 4 50.3 2013 5 59.8 2014 6 66.6 a) What type of pattern exists in the data? The time series plot shows an upward curvilinear trend. The time series plot shows a downward curvilinear trend.      The time series plot shows a downward linear trend. The time series...
The following table shows a company's annual revenue (in billions of dollars) for 2009 to 2014....
The following table shows a company's annual revenue (in billions of dollars) for 2009 to 2014. Year Period (t) Revenue ($ billions) 2009 1 23.8 2010 2 29.4 2011 3 37.8 2012 4 50.3 2013 5 59.7 2014 6 66.6 (a) Construct a time series plot. A time series plot contains a series of 6 points connected by line segments. The horizontal axis ranges from 0 to 7 and is labeled: Period. The vertical axis ranges from 0 to 80...
Consider the three stocks in the following table.  Pt represents price at time t, and Qt represents...
Consider the three stocks in the following table.  Pt represents price at time t, and Qt represents shares outstanding at time t. Stock C splits two-for-one in the last period. Can you show work with steps and answer c please                         P 0       Q 0     P 1      Q 1     P 2      Q 2             A         80        100      85        100      90        100             B         60        200      45        200      40        200             C         110      200      120      200      60        400 c. Calculate the rate of return of the price-weighted index for the second period (t=1 to t=2).
The following table represents short run cost-revenue information (in dollars) for a firm in a competitive...
The following table represents short run cost-revenue information (in dollars) for a firm in a competitive market. Q P TR MR MC TC Total Profit 0 N/A N/A 2,000 1 2,800 2 3,400 3 300 4 3,800 5 4,000 6 400 7 600 8 900 9 10 (a) Fill in all the blanks above using the following information: The Market Price is $500 per unit of output, the Average Variable Cost of producing 9 units of output is $800, and...
The following table represents short run cost-revenue information (in dollars) for a firm in a competitive...
The following table represents short run cost-revenue information (in dollars) for a firm in a competitive market. Q P TR MR MC TC Total Profit 0 N/A N/A $1,000 1 1,100 2 1,180 3 1,220 4 $20 5 1,270 6 1,320 7 $80 8 $100 9 10 (a) Fill in all the blanks above using the following information: The Market Price is $50 per unit of output, the TVC of producing 9 units of output is $700, and the ATC...
The following table represents short run cost-revenue information (in dollars) for a firm in a competitive...
The following table represents short run cost-revenue information (in dollars) for a firm in a competitive market. Q P TR MR MC TC Total Profit 0 0 N/A N/A 1000 1 200 1200 2 400 1340 3 600 60 4 800 1420 5 1000 1440 6 1200 60 7 1400 80 1580 8 1600 140 9 1800 10 2000 (a) Fill in all the blanks above using the following information: The Market Price is $200 per unit of output, the...
Consider the following table: Year Quantity of Money (billions of $) Velocity Real GDP (billions of...
Consider the following table: Year Quantity of Money (billions of $) Velocity Real GDP (billions of 2009 $) GDP Deflator 2006 $1,369 10.274 $14,717 2009 $1,684 8.650 1.002 2012 $2,434 6.696 $15,384 Fill in the missing data, using the quantity equation of money. Why might velocity change in this way? Calculate the average inflation rate between 2006 and 2009 and between 2009 and 2012. If velocity had remained at the 2006 level, what would the deflator have been in 2009...
The following table represents short run cost-revenue information (in dollars) for a firm in a competitive market.
The following table represents short run cost-revenue information (in dollars) for a firm in a competitive market.QPTRMRMCTCTotal Profit0N/AN/A1602503466056700773087709601080(a) Fill in all the blanks above using the following information: The Total Fixed Cost is $480. The Market Price is $40 per unit of output, the ATC of producing 3 units of output is $210, and the TVC of producing 5 units of output is $200(b) Where does diminishing returns start? __________(c) In the Short Run, if this firm would go into...
. The following table contains the weights of a group of 12 women, where x represents...
. The following table contains the weights of a group of 12 women, where x represents the woman’s average weight at age 17, and y represents the woman’s weight after menopause. Weights (in Pounds Weight at Age 17, x ----99-- 123-- 119 --87 --90 --101-- 98-- 121-- 131-- 134--135-- 97 Weight after Menopause, y ----------------121-- 156--145--109--111--137-- 128--142--149--152 --155-- 128 Enter this information on your calculator and then answer the following: a. What kind of linear relationship seems to exist between...
In the following table, the random variable x represents the number of laptop computers that failed...
In the following table, the random variable x represents the number of laptop computers that failed during a drop-test of six sample laptops. Use the table to answer the questions a) - e) below. x 0 1 2 3 4 5 6 P(x) 0.377 0.399 0.176 0.041 0.005 0.000 0.000 a) Find and report the mean and the standard deviation of this distribution. b) Using the range rule of thumb, identify the range of values containing the usual number of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT