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
Solving proportions-what’s 3 over 7 and 12 over 21? do the ratios from a proportion
Answer:
3:7 and 12:21
6:14
9:21
12:28
No they do not for a proportion
Step-by-step explanation:
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 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: 20Therefore, 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
Figure ABCD is a trapezoid. Find
the value of x.
B.
2x + 1
.C
17
3x + 8
.D
A
x = [?]
Answer for x is 5
Step by step explanation:
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
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]
Find a slope for each line (each block is one unit):
HELP THIS IS DUE TODAY.
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.
Find the missing length.
8
3
с
C =
= ✓ [?]
Pythagorean Theorem: a2 + b2 = 2
Answer:
✓73 or approximately 8.54
Step-by-step explanation:
✓ 8²+3² = ✓ 73 or approximately 8.54
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.
Answer:
the answer is 245
Step-by-step explanation:
Answer:
245
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?
Answer:
Your answer
420 were chocolate
Mark it as Brainlist. Follow me for more answer.
Step-by-step explanation:
Can someone help me plz
Answer:
what are you looking for in this picture.tell me and ill answer in tbe coments
Step-by-step explanation:
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?
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.
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
Answer:
the last one
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?
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 me plz ??? Help
Answer:
16
Step-by-step explanation:
I need help with the translation!
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 precent of change from 92 to 108
Help I have a math assignment due by 11:59 pm and I’m stuck!
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?
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
How many degrees are on
the interior of a Polygon that
has 18 sides?
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
PLEASE HELPPPPP PLEASREER
Answer:
its a :)
Step-by-step explanation:
hmu if you need an explanation or more help :)
Can someone help me with these two questions plss
Answer:
c. 6
d. 3
Step-by-step explanation:
:-)
What is the answer to 3/8 + 2/4
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.
Expand 3(y + 4).
3(y+4)=
Answer:
expanded it is x= 3(y+4)
Answer:
3*y + 3*4 = 3*m + 12
Step-by-step explanation:
Can someone help me with this problem? 3[x(-6)]
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!
need help with my IXL
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
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.
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
HELP PLEASE ILL GIVE BRAINIEST!!
a. What is f(2):
b. What is f(-4):
c. Find x when f(x) = 4 x=
Answer:
f(2) is -3
f(-4) is 2
for the last one, x = -2
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
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).
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
Convert into log form
a^b = c
Answer:
(c) ( c ) . logb(a)=c log b
Step-by-step explanation: