Question

In: Advanced Math

6. The following data represents a company’s revenue in millions of dollars. Year: 2010 2012 2014...

6. The following data represents a company’s revenue in millions of dollars. Year: 2010 2012 2014 2015 2016 2018 2019 Revenue: 30 32 34 35 39 39 45 Let the year 2010 be the base year with x=0.

a) Model the data with a linear function using the points in years 2010 and 2019. Round computed values to 2 decimal places. Also, using your model predict the revenue in the year 2021 accurate to 3 decimal places.

b) Set up a table of (x, y) values to be used for a least squares model and find a linear least squares model y ax b = + for the data. Express the coefficients a and b accurate to 3 decimal places. Also, what is the 2 R value accurate to 3 decimal places?

c) Use your least squares model to predict the revenue in 2020 accurate to 3 decimal places and graph the actual and predicted revenue data superimposed on the same graph.

Solutions

Expert Solution


Related Solutions

Using the data in the following​ table,    2010   2011   2012   2013   2014   2015 Stock A  ...
Using the data in the following​ table,    2010   2011   2012   2013   2014   2015 Stock A   -10%   20%   5%   -5%   2%   9% Stock B   21%   7%   30%   -3%   -8%   25% consider a portfolio that maintains a 50% weight on stock A and a 50% weight on stock B. a. What is the return each year of this​ portfolio? b. Based on your results from part ​(a​), compute the average return and volatility of the portfolio.
Refer to the following mentioned data. (In millions) 2014 2013 2012 Net revenues $ 8,268 $...
Refer to the following mentioned data. (In millions) 2014 2013 2012 Net revenues $ 8,268 $ 8,052 $ 7,175 Cost of products sold 5,370 5,140 4,365 Gross margin $ 2,898 $ 2,912 $ 2,810 (a) Calculate the gross profit ratio for each of the past three years. (Round your answers to 1 decimal place.) (b) Assume that Campbell’s net sales for the first four months of 2015 totaled $2.7 billion. Calculate an estimated cost of goods sold and gross profit...
2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Revenue 4,500 6,860 8,409 9,082...
2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Revenue 4,500 6,860 8,409 9,082 9,808 10,593 11,440 12,355 13,344 14,411 Revenue Growth 52.4% 22.6% 8.0% 8.0% 8.0% 8.0% 8.0% 8.0% 8.0% Production Costs Fixed Production Expense (excl depreciation) 575 575 587 598 610 622 635 648 660 674 Variable Production Costs 2,035 3,404 4,291 4,669 5,078 5,521 6,000 6,519 7,079 7,685 Depreciation 152 152 152 152 164 178 192 207 224 242 Total Production Costs 0 2,762 4,131...
Year Population in Millions GDP in Trillions of US$ 2014 318.86 16.29 2011 311.72 15.19 2010...
Year Population in Millions GDP in Trillions of US$ 2014 318.86 16.29 2011 311.72 15.19 2010 309.35 14.94 2009 306.77 14.54 2008 304.09 14.58 2006 298.38 14.72 2004 292.81 13.95 2003 290.11 13.53 2002 287.63 12.96 2001 284.97 12.71 2000 1999 279.04 12.32 1998 275.85 11.77 1990 249.62 8.91 1989 246.82 8.85 1987 242.29 8.29 1986 240.13 7.94 1985 237.92 7.71 1984 235.82 7.4 1982 231.66 6.49 1981 229.47 6.59 1980 6.5 1979 225.06 6.5 1977 220.24 6.02 1976 218.04...
Year Population in Millions GDP in Trillions of US$ 2014 318.86 16.29 2011 311.72 15.19 2010...
Year Population in Millions GDP in Trillions of US$ 2014 318.86 16.29 2011 311.72 15.19 2010 309.35 14.94 2009 306.77 14.54 2008 304.09 14.58 2006 298.38 14.72 2004 292.81 13.95 2003 290.11 13.53 2002 287.63 12.96 2001 284.97 12.71 2000 1999 279.04 12.32 1998 275.85 11.77 1990 249.62 8.91 1989 246.82 8.85 1987 242.29 8.29 1986 240.13 7.94 1985 237.92 7.71 1984 235.82 7.4 1982 231.66 6.49 1981 229.47 6.59 1980 6.5 1979 225.06 6.5 1977 220.24 6.02 1976 218.04...
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...
The following data show the annual revenue ($ millions) and the estimated team value ($ millions)...
The following data show the annual revenue ($ millions) and the estimated team value ($ millions) for the 30 Major League Baseball teams (Forbes website, January 16, 2014). Team Revenue ($ millions) Value ($ millions) Arizona Diamondbacks 195 584 Atlanta Braves 225 629 Baltimore Orioles 206 618 Boston Red Sox 336 1312 Chicago Cubs 274 1000 Chicago White Sox 216 692 Cincinnati Reds 202 546 Cleveland Indians 186 559 Colorado Rockies 199 537 Detroit Tigers 238 643 Houston Astros 196...
The following data show the annual revenue ($ millions) and the estimated team value ($ millions)...
The following data show the annual revenue ($ millions) and the estimated team value ($ millions) for the 30 Major League Baseball teams (Forbes website, January 16, 2014). Team Revenue ($ millions) Value ($ millions) Arizona Diamondbacks 195 584 Atlanta Braves 225 629 Baltimore Orioles 206 618 Boston Red Sox 336 1312 Chicago Cubs 274 1000 Chicago White Sox 216 692 Cincinnati Reds 202 546 Cleveland Indians 186 559 Colorado Rockies 199 537 Detroit Tigers 238 643 Houston Astros 196...
The following data show the annual revenue ($ millions) and the estimated team value ($ millions)...
The following data show the annual revenue ($ millions) and the estimated team value ($ millions) for the 30 Major League Baseball teams (Forbes website, January 16, 2014). Team Revenue ($ millions) Value ($ millions) Arizona Diamondbacks 195 584 Atlanta Braves 225 629 Baltimore Orioles 206 618 Boston Red Sox 336 1312 Chicago Cubs 274 1000 Chicago White Sox 216 692 Cincinnati Reds 202 546 Cleveland Indians 186 559 Colorado Rockies 199 537 Detroit Tigers 238 643 Houston Astros 196...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT