1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
GuDViN [60]
2 years ago
15

Giovanni Food Products produces and sells frozen pizzas to public schools throughout the eastern United States. Using a very agg

ressive marketing strategy they have been able to increase their annual revenue by approximately $10 million over the past 10 years. But increased competition has slowed their growth rate in the past few years. The annual revenue, in millions of dollars, for the previous 10 years is contained in the Excel Online file below. Construct a spreadsheet to answer the following questions.
Year Revenue
1 8.53
2 10.84
3 12.98
4 14.11
5 16.31
6 17.21
7 18.37
8 18.45
9 18.40
10 18.43
a. Construct a time series plot. Comment on the appropriateness of a linear trend.
b. Using Minitab or Excel, develop a quadratic trend equation that can be used to forecast revenue.
c. Using the trend equation developed in part (b), forecast revenue in year 11.
Mathematics
1 answer:
scoray [572]2 years ago
5 0

Answer:

a-1. See part a-1 of the attached excel file for the time series plot.

a-2. The linear trend is not appropriate

b. The quadratic trend equation is y = -0.1618x^2 + 2.889x + 5.7022

c. Revenue in year 11 is 17.90.

Step-by-step explanation:

a-1. Construct a time series plot. Comment on the appropriateness of a linear trend.

Note: See part a-1 of the attached excel file for the time series plot.

a-2. Comment on the appropriateness of a linear trend.

Note: See part a-2 of the attached excel file for the time series plot with a linear trend.

From the time series plot with a linear trend, it can be seen that the movements of the time series plot and the linear trend are not the same. This implies that the linear trend is not appropriate

b. Using Minitab or Excel, develop a quadratic trend equation that can be used to forecast revenue.

Note: See part b of the attached excel file for the quadratic equation trend.

From the quadratic equation trend, we obtained the following quadratic trend equation that can be used to forecast revenue:

y = -0.1618x^2 + 2.889x + 5.7022 ……………. (1)

Where;

y = Revenue

x = Year

c. Using the trend equation developed in part (b), forecast revenue in year 11.

Substituting x = 11 into equation (1), we have:

y = (-0.1618 * 11^2) + (2.889 * 11) + 5.7022 = 17.90

Therefore, revenue in year 11 is 17.90.

Download xlsx
You might be interested in
Somebody help.. im so lost!!
aleksley [76]
What type of math is this?
4 0
3 years ago
Chanelle deposits $7,500 into the bank. She does not withdraw or deposit money for 6 years. She earns 6% interest during that ti
koban [17]

Answer: a. $2700

b. $10200

Step-by-step explanation:

a. The interest she would have earned at the end of the 6 years can be gotten using the formula

= PRT/100

= $7500 × 6% × 6

= $7500 × 6/100 × 6

= $7500 × 0.06 × 6

= $2700

b. Her balance when she wants to withdraw the money would be:

= $7500 + $2700

= $10200

5 0
3 years ago
Find the angle between the given vectors to the nearest tenth of a degree. u = (8, 4), v = (9, -9)
Usimov [2.4K]

Answer:

<em>71.6 degrees </em>

Step-by-step explanation:

The formula for calculating the angle between two vectors is expressed as;

u.v = |u||v|cos theta

u.v = (8, 4).(9, -9)

u.v = 8(9)+4(-9)

u.v = 72-36

u.v = 36

|u| = √8²+4²

|u| = √64+16

|u| = √80

|v| = √9²+(-9)²

|v| = √81+81

|v| = √162

36 = √80*√162 cos theta

36 = √12960 cos theta

36 = 113.84 cos theta

cos theta = 36/113.84

cos theta = 36/113.84

cos theta = 0.3162

theta = arccos (0.3162)

<em>theta = 71.6 degrees </em>

<em>Hence the angle between the given vectors is 71.6 degrees </em>

7 0
3 years ago
Read 2 more answers
The weather man announced that there was a temperature drop Of 8 degrees from yesterday to today. How would this be represented
uysha [10]

that will be not so shore of what will you think but if you used a thermometer and you see how it will change

8 0
3 years ago
Someone please help me!
Ludmilka [50]
The answer is 180 miles
4 0
3 years ago
Other questions:
  • Which function is graphed on the right?
    12·1 answer
  • Two consecutive odd numbers sum to 128. Find the numbers.
    13·1 answer
  • Please help i'm not that good at math. Determine the number of real solutions for each system of equations.
    11·2 answers
  • Solve n for the following preportion :<br><img src="https://tex.z-dn.net/?f=%20%5Cfrac%7B3%7D%7B5%7D%20%20%3D%20%20%5Cfrac%7B12%
    12·1 answer
  • A diagram is drawn to scale, so 1.0 cm represents a velocity of 10 m/s. On the diagram, there is a vector 7.0 cm long. What is t
    7·2 answers
  • A politician wants to distribute campaign flyers to 8000 homes in his district. The color flyers cost him $0.08 each, and the bl
    9·1 answer
  • Suppose you are given either a fair dice or an unfair dice (6-sided). You have no basis for considering either dice more likely
    12·1 answer
  • Pablo has a busy semester, and he does not want to give too much time to Statistics. So he puts off working through the course,
    8·1 answer
  • The number 42 is composite or prime.
    6·2 answers
  • Write a proof that shows how 45 and 4.5 have a factor of 10
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!