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
Colby Messinger answered 1 year agoRelated Solutions
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...
Consider the following data ( in millions of dollars): Year Real DI Real C 0 1900...
Consider the following data ( in millions of dollars): Year Real
DI Real C 0 1900 1839 1 2000 1935 2 1700 1647
For now, assume that no other variable ( besides disposable
income) that could affect real consumption has changed between Year
0, Year 1, and Year 2. a.) Draw the general shape of the
consumption function. b.) Solve for the marginal propensity to
consume ( show your work). c.) What is the slope of this
consumption function (...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Research publicly traded companies and select two companies in different sectors. Provide a written comparison of...
- You are working as a consultant and are assigned the task to set up a secure...
- Suppose you are starting work on a project for an organization that has never used any...
- Answer must be a 100 word minimum paragraph The principle of USP can effectively highlight the...
- The parameters that determine the performance of cornstarch as thickener. How to determine these parameters？ What...
- Why would a self-assessment that gives a snapshot of confidence levels at transitions, along with personal...
- How “socially desirable response” constitutes a threat for psychological measurement? Provide an example. In scientific research,...
ADVERTISEMENT