use a 2-year weighted moving average to calculate forecasts for the years 1992-2002, with the weight of 0.7 to be assigned to the most recent year data. ("sumproduct" function must be used.)

Answers

Answer 1

The weighted moving average formula with weights of 0.3 and 0.7 can be calculated using the AVERAGE and SUMPRODUCT functions in Excel. This formula can be used to calculate forecasted values for a range of years.

To use a 2-year weighted moving average to calculate forecasts for the years 1992-2002 with the weight of 0.7 assigned to the most recent year data, we can use the SUMPRODUCT function.
First, we need to create a table that includes the years 1990-2002 and their corresponding data points. Then, we can use the following formula to calculate the weighted moving average:
=(0.3*AVERAGE(B2:B3))+(0.7*B3)
This formula calculates the weighted moving average for each year by taking 30% of the average of the data for the previous two years (B2:B3) and 70% of the data for the most recent year (B3). We can then drag the formula down to calculate the forecasted values for the remaining years.
The SUMPRODUCT function can be used to simplify this calculation. The formula for the weighted moving average using SUMPRODUCT would be:
=SUMPRODUCT(B3:B4,{0.3,0.7})
This formula multiplies the data for the previous two years (B3:B4) by their respective weights (0.3 and 0.7) and then sums the products to calculate the weighted moving average for the most recent year. We can then drag the formula down to calculate the forecasted values for the remaining years.
In summary, the weighted moving average formula with weights of 0.3 and 0.7 can be calculated using the AVERAGE and SUMPRODUCT functions in Excel. This formula can be used to calculate forecasted values for a range of years.

To know more about function visit :

https://brainly.com/question/12195089

#SPJ11


Related Questions

Can someone help me with these two questions plss

Answers

Answer:

c. 6

d. 3

Step-by-step explanation:

:-)

How is the finance charge calculated for credit cards?

A. APR times Remaining Balance

B. APR times Average Daily Balance

C. MPR times Remaining Balance

D. MPR times Average Daily Balance

Answers

Answer:

A. APR times Remaining Balance

Answer:

Answer is B I believe

Step-by-step explanation:

A common way of calculating a finance charge on a credit card is to multiply the average daily balance by the annual percentage rate (APR).

HELP PLEASE ILL GIVE BRAINIEST!!
a. What is f(2):
b. What is f(-4):
c. Find x when f(x) = 4 x=

Answers

Answer:

f(2) is -3

f(-4) is 2

for the last one, x = -2

Step-by-step explanation:

Expand 3(y + 4).
3(y+4)=

Answers

Answer:

expanded it is x= 3(y+4)

Answer:

3*y + 3*4 = 3*m + 12

Step-by-step explanation:

Figure ABCD is a trapezoid. Find
the value of x.
B.
2x + 1
.C
17
3x + 8
.D
A
x = [?]

Answers

Answer for x is 5

Step by step explanation:

Convert into log form
a^b = c

Answers

Answer:

(c) ( c ) . logb(a)=c log b

Step-by-step explanation:

Your family got a coupon for 35% off at Red Robin. Your bill comes to $45.00 before you use the coupon. Sales tax on the discounted meal is calculated at 8%. You then leave a 15% tip based on the original cost of the meal. How much will dinner and tip cost?

Answers

Answer: $38.34

Step-by-step explanation:

Original bill total: $45

35% discount: $15.75

subtotal: $29.25

sales tax: 8% of $29.25: $2.34

bill for meal: $29.25 + $2.34 = $31.59

Tip: 15% of original cost of meal: 15% of $45: $6.75

TOTAL COST: $31.59 + $6.75 = $38.34

Help I have a math assignment due by 11:59 pm and I’m stuck!

Answers

Answer:

answer C: 140 cm

Step-by-step explanation:

If the water rises 14cm in 2 seconds, 21cm in 3 seconds etc... Then the water rises at 7cm per second. Multiply this by 20 seconds and you get 140cm

By find how high the water would be after 20 seconds, you would find out much height is increasing each second.

21 - 4 = 7

28 - 21 = 7

35 - 35 = 7, and so forth.

So, we know that 7 cm is increasing each second. You would just add 7 to the height for each second.

2 --> 14

3 --> 21

4 --> 28

5 --> 35

6 --> 42

7 --> 49

8 --> 56

9 --> 63

10 --> 70

11 --> 77

12 --> 84

13 --> 91

14 --> 98

15 --> 105

16 --> 112

17 --> 119

18 --> 126

19 --> 133

20 --> 140

Thus, after 20 seconds, the water's height would be c) 140 cm.

Which answer choice correctly identifies the missing information in the problem? Joey and Kirk are in the 6th grade. Kirk is 5 feet 4 inches tall. Joey is 4 feet 8 inches tall. How much taller is Kirk than Joey?

Answers

Answer:Kirk is taller than Joey by 8 inches

Step-by-step explanation:

Step 1

Kirk's height is given as  =5 feet 4 inches tall.

Joey's  height 4 feet 8 inches tall

Difference in height = 5 feet 4 inches

                                    - 4 feet   8 inches

                                 =

Step 2

Bear in mind that 12 inches = 1 feet . Now,8 cannot be subtracted from 4 , so we borrow 1 feet from 5feet,  which is equivalent to 12 inches and add to inches  so it becomes

4 feet  (12+4)inches     =                   4 feet     16inches

- 4 feet   8 inches                             - 4 feet   8 inches

                                                     =                   8 inches

Therefore Kirk is taller than Joey by 8 inches

what is the precent of change from 92 to 108

Answers

108-92=16
16 divide 92=0.173913 multiply by 100=17.3913%
ANSWER
17.39% in change

A flagpole casts a shadow 16 feet long.
Shanika is standing near the pole. Her
shadow is 4 feet long. Shanika's height is 5
feet. How tall is the flagpole?

Answers

Step-by-step explanation:

Since Shanika is standing near the pole, we can safely assume that the triangle formed by Shanika and her shadow is a smaller version of the triangle formed by the pole and its shadow.

By similar triangles:

[tex] \frac{x \: of \: pole}{y \: of \: pole} = \frac{x \: of \: shanika}{y \: of \: shanika} \\ \frac{16}{ height \: of \: pole} = \frac{4}{5} \\ 16(5) = 4 \times height \: of \: pole \\ height \: of \: pole = \frac{80}{4} \\ = 20[/tex]

The height of the pole is 20ft.

Help me plz ??? Help

Answers

Answer:

16

Step-by-step explanation:

Can someone help me with this problem? 3[x(-6)]

Answers

Answer:

-18x

Step-by-step explanation:

First step: remove the parentheses.

So, you'll have -3x*6.

multiply the numbers (3 x 6 = 18)

and you'll get -18x.

hope this helps!

HELP THIS IS DUE TODAY.

Answers

Answer:

You can try for the first pic x = 2 and 6 and you can try the second pic x = 0 and 3 (The ones that I put missing). If you need any help in them, I will help you out but try half of them by yourself. Hopw this helps, thank you :) !!

Look at the third picture. Maybe that would help you.

Point P is located at (−2, 7), and point R is located at (1, 0). Find the y value for point Q that is located two-thirds the distance from point P to point R.

4.9
4.7
2.5
2.3

Answers

Answer:

The answer is 4.7

Step-by-step explanation:

[tex]y = \frac{l1y1 + l2y2}{l1 + l2} \\ y = \frac{ \frac{2}{3} \times 7 + \frac{1}{3} \times 0 }{ \frac{2}{3} + \frac{1}{3} } \\ y = \frac{14}{3} = 4.7[/tex]

How many degrees are on
the interior of a Polygon that
has 18 sides?

Answers

Answer:

ask yourself

Step-by-step explanation:

Answer:

160.00° Degrees

Step-by-step explanation:

To find the answer, we have to use the interior angle formula which is

(n-2)*180, where n is the number of sides. This formula gives us the sum of all interior angles in a polygon having ‘n’ sides.

For a polygon with 18 equal sides, first finding the sum of all interior angles of the polygon:-

=(n-2)*180= (18–2)*180=16*180=2880 degree.

We found the sum of all interior angles of 18 sided polygon and it is 2880 degrees.

The polygon we are considering has all sides equal, which means it is a regular polygon. So we can conclude that all of its interior angles are equal.

Sum of all eighteen angles=2880, One angle=2880/18=160 degrees.

Thus, we concluded that the interior angle of the regular eighteen sided polygon

is 160 degrees

Find a slope for each line (each block is one unit):

Answers

Where’s the graph? Just wondering so I can help you out

Solving proportions-what’s 3 over 7 and 12 over 21? do the ratios from a proportion

Answers

Answer:

3:7 and 12:21

6:14

9:21

12:28

No they do not for a proportion

Step-by-step explanation:

EXPLANATION PLEASE BRAINLIEST
Which of the following was an aim of President Wilson’s Fourteen Points?
A. Self-determination
B. American isolationism
C. Stockpiling arms
D. Tariffs on trade

Answers

B because it’s taking about the President

WILL MARK BRAINLEST, 15 POINTS
HURRY FAST

Two trains leave the station at the same time, one heading east and the other west. The eastbound train travels at 80 miles per hour. The westbound train travels at 90 miles per hour. How long will it take for the two trains to be 204 miles apart?
Do not do any rounding.

Answers

Answer:

one hour and 12 minutes

Answer:

1  hour and 12 minutes

Step-by-step explanation:

Let's say x = time it takes for the trains to be 204 miles apart.

Speed = Distance/Time,

Time = Distance/Speed,

x = 204/ (80 + 90) = 204/170 = 1 and 1/5 hours or 1  hour and 12 minutes

tim played 20 games of draughts he won 16 of those games.what fraction of the game did he win
b) he played 30more games he had then 68% of all his games how amny of 30 games did he win

Answers

Answers to both subparts are shown:

(A) The fraction of games Tim wins is 4/5.(B) Tim wind has 20 games when he plays 30 games.

What is a fraction?Any number of equal parts is represented by a fraction, which also represents a portion of a whole. A fraction, such as one-half, eight-fifths, or three-quarters, indicates how many components of a particular size there are when stated in ordinary English. An element of a whole is a fraction. The number is represented mathematically as a quotient, where the numerator and denominator are split. Both are integers in a simple fraction.

So, (A) fraction of the game Tim wins:

The number of games played is 20.The game won is 16.

Then, the fraction will be:

16/204/5

(B) Games Tim wins in 30 games.

The total number of games played is 30.The winning percentage is 68%.

So, a number of games won:

30/100 × 680.30 × 6820.4Rounding off: 20

Therefore, answers to both subparts are shown:

(A) The fraction of games Tim wins is 4/5.(B) Tim wind has 20 games when he plays 30 games.

Know more about fractions here:

https://brainly.com/question/78672

#SPJ1

The correct question is shown below:

(A) tim played 20 games of draughts he won 16 of those games.what fraction of the game did he win

b) he played 30 more games he had then 68% of all his games how amny of 30 games did he wi

I need help with the translation!

Answers

Answer:

Step-by-step explanation:

All points C, D, E, F are translated 4 units to the right and 4 units down.

What is the answer to 3/8 + 2/4

Answers

Answer:

1 1/2

Step-by-step explanation:

1.) First find the common denominator of the 2 fractions (8)    4: 4

    8: 4, 8

2.) then you write a new expression with the numerator left blank and the denominator as 8 shown below in the step by step explanation.  /8 + /8

3.)3/8 + 2/4 multiply by 1 both numerator and denominator for the first fraction. And multiply by 2 both numerator and denominator for the second fraction. 3/8 + 4/8.

4.) Then you add those 2 fractions which I assume you already know how by adding the numerators together, and get 12/8.

5.) You simplify 12/8 and get 1 4/8. 4/8 is equal to 1/2 so its 1 1/2.

Allen received a paycheck for $500. He spent $200 for rent, $55 for food, and $20 for gas. Now, he has only $175 left. How much money is unaccounted for? (Let m stand for the unaccounted-for amount of money.

Answers

Answer:

the answer is 245

Step-by-step explanation:

Answer:

245

Step-by-step explanation:

Find the missing length.
8
3
с
C =
= ✓ [?]
Pythagorean Theorem: a2 + b2 = 2

Answers

Answer:

✓73 or approximately 8.54

Step-by-step explanation:

✓ 8²+3² = ✓ 73 or approximately 8.54

need help with my IXL

Answers

Answer:

TU= 4 mm

Step-by-step explanation:

a^2+b^2=c^2

3^2+b^2=5^2

9+b^2=25

b^2=16

b=4

PLEASE HELPPPPP PLEASREER

Answers

Answer:

its a :)

Step-by-step explanation:

hmu if you need an explanation or more help :)

While going on a date to the movies, you offer to buy the snacks. You plan to buy two packs of candy (one for each of you) and a large popcorn to share. If you have 15 dollars and a large popcorn costs 7 dollars, what’s the most you can spend on a pack of candy?

$3.50

$4.00

$6.50

$8.00

Answers

$4.00 because

$15 - $7 = $8 than divide it by 2 which gives the $4 dollars for each 2 people

Answer:

the last one

Step-by-step explanation:

A bakery sells chocolate cupcakes and mocha cupcakes. It sold 500 cupcakes in a day, and 16% of them were mocha. How many of the cupcakes sold that day were chocolate?

Answers

Answer:

Your answer

420 were chocolate

Mark it as Brainlist. Follow me for more answer.

Step-by-step explanation:

Can someone help me plz

Answers

Answer:

what are you looking for in this picture.tell me and ill answer in tbe coments

Step-by-step explanation:

Other Questions
A grindstone increases in angular speed from 4.00 rad/s to to12.00 rad/s in 4.00 s. Through what andle does it turn duringthat time if the angular acceleration is constant?a) 8.00 radb) 12.0 radc) 16.00 radd) 32.0 rade) 64 rad Adjustments in dial indicator readings should be made to compensate for _______. A. Indicator sag B. Shaft vibration C. Shaft end float D. Corrosion when setting advertising objectives, what is the difference in a push and a pull strategy? provide an example of when each might be used. Please help me anwser this Problem 1 (30 pts) A coaxial cable has an inner radius of a = 0.5[mm] and an outer radius of b= 2 [mm]. The coax is filled with (nonmagnetic) Teflon having &, = 2.1 and tan d = 0.001. The conductors are made of copper, having a conductivity of o = 3.0x10' [S/m]. The copper conductors are nonmagnetic (u= uo). a) Find the attenuation constant a in [nepers/m] at a frequency of 100 [MHz]. b) Assume that we are now operating at a frequency where a = 0.05 [nepers/m]. How far along the cable do we have to go so that the signal amplitude is 15 dB smaller than at the beginning? The act of applying a valued consequence to increase a behavior is referred to as: what is a valid credit card number Solve the system of equations :-) Thank you Jose worked 44 hours and his regular pay is $14.00/hour. How much did he make forovertime hours if regular working week is 40 hours.$84.00$68.00O $616.00O $924.00 compute the second-order partial derivative of the function (,)= 25. An auditor most likely would apply analytical procedures in the overall review stage of an audit to Required Information Problem 16.015 - DEPENDENT MULTI-PART PROBLEM - ASSIGN ALL PARTS NOTE: This is a multi-part question. Once an answer is submitted, you will be unable to return to this part At the instant shown the tensions in the vertical ropes AB and DE are 300 N and 200 N, respectively. D 0.4m 30 0.4 m 1.2 mKnowing that the mass of the uniform bar BE is 6.6 kg, determine, at this instant, the force P.Knowing that the mass of the uniform bar BE is 6.6 kg, determine, at this instant, the magnitude of the angular velocity of each rope.Knowing that the mass of the uniform bar BE is 7 kg, at this instant, determine the angular acceleration of each rope a glass lens ( =1.60 ) has a focal length of =32.4 cm and a planoconcave shape. calculate the magnitude of the radius of curvature of the concave surface. 2.for you, what are the components of comfortdo they include flexible hours, working in an office instead of outside, something else? can you rank the components as more and less important? which lists types of materials from most conductive to least conductive? If the several oligopolistic firms that comprise an industry behave collusively, the resulting price and output will most likely resemble those of:pure monopoly.pure competition.monopolistic competition.bilateral monopoly. create the following 19 x 19 matrix in matlab without typing it in directly An oil film (n = 1.45) floating on water is illuminated by white light at normal incidence. The film is 280 `nm thick. Find (a) the color of the light in the visible spectrum most strongly reflected and (b) the color of the light in the spectrum most strongly transmitted. Explain your reasoning. Lara's bedroom door is 9 feet tall and 4 feet wide. A new door would cost $5.93 per square foot. How much would a new bedroom door cost in total?$ What was the root cause of waste in the first 2 rounds of the Paper Airplane Game? A. Improper training of the bottleneck resource. B. Inferior performance of the bottleneck resource C. Not enough airplanes per round the learning curve idea would've eventually eliminated all waste. D. Laziness by non-bottleneck workers. E.The rigid process and organization