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
|v+8| -5=2 Help please
Galina-37 [17]

Answer:

v= -1 (BRAINLIEST PLEASE)

Step-by-step explanation:

|v+8| -5=2

Add 5 to each side

|v+8| -5=2

      +5= +5

Now you have |v+8|= 7

So what plus 8 equals 7?

-1

so now you have |-1+8| which is 7

so v= -1

3 0
3 years ago
Find the distance from point A(−9,−3) to the line y = x−6. Round your answer to the nearest tenth.
Vladimir79 [104]

The distance from point A(−9,−3) to the line y = x−6 is 8.5 units

<u>What is slope ?</u>

A line's steepness is determined by its slope. In mathematics, slope is determined by "rise over run" (change in y divided by change in x).

step 1

Find the slope of the perpendicular line to the given line

y=x-6 ---> given line

The slope is m=1

Remember that

If two lines are perpendicular, then their slopes are opposite reciprocal (the product of their slopes is equal to -1)

m1*m2 = -1

we have

m1=1

substitute

(1)*m2 = -1

so

m2 = -1

step 2

Find the equation of the perpendicular line to the given line

The equation in point slope form is

y-y1=m(x-x1)

we have

m=-1

(x1,y1)=(−9,−3)

substitute

y+3=-1(x+9)--> equation in point slope form

y+3= -x-9

y= -x-12---> equation in slope intercept form

step 3

Find the intersection point between the given line and the perpendicular line to the given line

we have the system of equations

y = x−6.

y= -x-12

Solve the system by graphing

The intersection point is (-3,-9)

see the attached figure

step 4

we know that

The distance between the point A and the point (-3,-9) is the same that the distance between point A and the line y=x-6

the formula to calculate the distance between two points is equal to

d=√[(y2-y1)² + (x2-x1)²]

substitute the values

d=√[(-9+3)² + (-3+9)²]

d= √72 units

simplify

d= 6√2 = 8.5 units

To learn more about the slope from the given link

brainly.com/question/16949303

#SPJ1

8 0
1 year ago
Why maths is an abstract subject​
Alla [95]
Abstraction in mathematics is the process of extracting the underlying structures, patterns or properties of a mathematical concept, removing any dependence on real world objects with which it might originally have been connected, and generalizing it so that it has wider applications or matching among other abstract
7 0
3 years ago
How do you write 30.0 in scientific notation? ____× 10^_____
Pie

Answer:

It's written as

3 \times  {10}^{1}

Hope this helps you

8 0
3 years ago
Read 2 more answers
Need help please assist me find the area of a regular hexagon
garri49 [273]

Answer:

The area of the regular hexagon is 166.3\ units^{2}

Step-by-step explanation:

we know that

The area of a regular hexagon can be divided into 6 equilateral triangles

so

step 1

Find the area of one equilateral triangle

A=\frac{1}{2}(b)(h)

we have

b=r=8\ units

h=4\sqrt{3}\ units ----> is the apothem

substitute

A=\frac{1}{2}(8)(4\sqrt{3})

A=16\sqrt{3}\ units^{2}

step 2

Find the area of 6 equilateral triangles

A=(6)16\sqrt{3}=96\sqrt{3}=166.3\ units^{2}

7 0
3 years ago
Other questions:
  • What is the interquartile range for the data set? 89, 91, 95, 112, 118, 83, 85, 104, 118, 125, 134, 138 Enter your answer in the
    13·1 answer
  • Which of the following has the same value as 65% of 20
    15·1 answer
  • The volume of a cube is 1 cubic meter. What is the length of of each side of the cube
    7·1 answer
  • Please help me on this!!!!!!
    11·1 answer
  • Find the value of 14x3+12 divide 4
    9·2 answers
  • 6th 7th 8th
    15·1 answer
  • In the coordinate plane, when you move an ordered pair (x,y) to the right, _______
    12·1 answer
  • Help!!! 10 points dhdhdhhhshmsmhsm
    13·1 answer
  • (8c+2a) (4+b) please solve this​
    9·1 answer
  • Prove the following identity : csc4x−cot4x=csc2x+cot2x .
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!