Question: Can someone explain this excel error to me? Its giving me a #VALUE error but I don't have any idea why!!! OOO AutoSave OFF AGE

Can someone explain this excel error to me? Its giving me a #VALUE error but I don't have any idea why!!!Can someone explain this excel error to me? Its

Can someone explain this excel error to me? Its

OOO AutoSave OFF AGE Books Q-show formula Home Insert Draw Page Layout Formulas Data Review View Acrobat Tell me 1-7 Share Comments fx - vlev V y Define Name Dfx loo Y Calculate Now loud B Trace Pracadents a Trace Dependents Show Frror Watch FRemove Arrows Formulas Checking Window O que Date & Lookup & Math & More Time Reference Trig Functions Insart Function Text Auto Sum Recently Financial Lagical Lised E Croata from Salection Calculation calculata Sheet Options H15 x fx =TREND($G$2:$G$121,$C$2:$C$121,015) A B D E F G H 1 1 8 1 Year 2 1987 3 1987 1987 1987 1987 7 1987 3 1987 1987 0 1987 1 1987 2 1987 2 3 1987 4 1988 5 1988 6 1988 7 1988 8 1988 9 1988 0 1988 1 2 3 3 4 5 6 7 8 Deseasonalized Month Period Profit Seasonal (monthly average Seasonal Indices Data Linear Trend Jan 95 -AVERAGE(D2,14,026,038,D50 D62.D 74,086,098,D110) -E2/AVERAGE($E$2:$E$13) -DF2 TREND($G$2:$G$121,$C$2:$C$121,C2) Feb AVERAGE(D3,D15,027,039,051,063,075,087,099,01111 E3/AVERAGE($E$2:$E$137 03/19 TREND$2:$G$121,$C$2:$C$121,03) March 3 198 AVERAGE(D4,D16,D28,040,052,064,076, D88,D100, D112) =E4/AVERAGE($E$2:$E$13) -D4/FA TREND($G$2:$G$121,$C$2:$C$121,C4) April 4 196 -AVERAGE(DS, D17,029,041,053,065,077, D89,0101,D113) -E5/AVERAGE($E$2:$E$13) -D5/F5 TREND($G$2:$G$121,$c$2:$C$121,C5) May 5 95 -AVERAGE(D6, D18,030,042,054,D66,078, D90,0102,D114) -E6/AVERAGE($E$2:$E$13) -D6/F6 TREND($G$2:$G$121,$c$2:$C$121,C6) June 16 115 -AVERAGE(D7,019,D31,043,055,067,029, D91,D103,D115) =E7/AVERAGE($E$2:$E$13) -D7/F7 TREND($G$2:$G$121,$C$2:$C$121,c7) July 7 107 -AVERAGE(D8,020,032,044,D56,068,080, D92,8104,D116) -E8/AVERAGE($E$2:$E$13) -D8/F8 TREND($G$2:$G$121,$C$2:$C$121,08) August 104 - AVERAGE(D3,D21,033,045,D57,069,081, 193,0105 D11AE9/AVERAGE($E$2:$E$13) -D9/F9 TREND($G$2:$G$121,$C$2:$C$121,09) September 9 96 - AVERAGE(D10,022,D34,D46,058,070,082, D94,D106,D118) -E107AVERAGE($E$2:$E$13) =D10/F10 TREND($G$2:$G$121,$C$2:$C$121,010) October 10 112 -AVERAGE(D11,023,035,047,059,071,083, D95,D107,D119) -E11/AVERAGESES2:$E$13) =D11/F11 TREND($G$2:$G$121,$C$2:$C$121,011) November 11 98 =AVERAGE(D12,D24,D36,048,060,072,D84, D96,D108,D120) =E12/AVERAGE($E$2:$E$131 D12/F12 TREND($G$2:$G$121,$c$2:$C$121,012) December 12 102 =AVERAGE(D13,025,037,049,061,073,085, 097,0109,D121) E13/AVERAGE($E$2:$E$13) -D13/13 -TREND($G$2:$G$121,$C$2:$C$121,C13) January 13 104 =F2 =D14/F14 TRENDI$G$2:$G$121,$C$2:$C$121,C14) February 100 =F3 =D15/F15 ! TREND$2:$G$121,$C$2:$C$121,015) March 15 199 =F4 =D16/F16 =TREND($G$2:$G$121,$C$2:$C$121,016) April 16 188 =F5 =D17/F17 -TREND($G$2:$G$121,$C$2:$C$121,017) May 17 89 =F6 =D18/F18 -TREND($G$2:$G$121,$C$2:$C$121,018) June 18 108 =F7 =D19/F19 TREND($G$2:$G$121,$C$2:$C$121,019) July 19 109 =F8 =D20/F20 -TREND($G$2:$G$121,$C$2:$C$121,C20) Seasonal Forecast H2 F2 H3 F3 H4*F4 H5*F5 H6*F6 H7*F7 H8*F8 H9*F9 -H10 F10 H11 F11 -H12*F12 H13*F13 H14F14 H15*F15 =H16 F16 -H17*F17 -H18*F18 -H19 F19 -H20*F20 OO AutoSave OFF AGO... Book9 Q show formula Home Insert Draw Page Layout Formulas Data Review View Acrobat Tell me Share Comments fx ? A . Define Name Ofic 1 ln Calculate Now Trace Precedents Trace Dependents Shaw Error Watch FRemove Arrows Formulas Chacking Window 1 Insert Function AutoSum Recently Financial Lagical Used Text Date & Lookup & Math & Time Heference Trig More Functions Creata from Selection Calculation calculata Sheet Options H2 fx =TREND($G$2:$G$121, $C$2:$C$121,C2) A B E F G H 1 1 Year 2 1987 3 1987 4 1987 5 1987 6 1987 7 1987 8 1987 9 1987 10 1987 11 1987 12 1987 13 1987 14 1988 15 1986 16 1988 17 1988 18 1988 19 1988 20 1988 21 22 23 24 Deseasonalized Month Period Profit Seasonal (monthly average Seasonal Indices Data Linear Trend Jan 1 195 =AVERAGE(D2,14,D26,038,050,062,074,086,098,D110) = 2/AVERAGE($E$2:$E$13) =D2/F2 1.1 =TREND(SG$2:$G$121,$C$2:$C$121,C2) Feb 2 94 =AVERAGE(D3,D15,027,039,051,063,075,087,099,0111) =E3/AVERAGE($E$2:$E$13) =D3/F3 =TREND($G$2:$G$121,$C$2:$C$121,6) March 3 98 =AVERAGE(04,016,028,040,052,064,076, D88,D100,0112) =E4/AVERAGE(SE$2:$E$13) =D4/F4 =TREND($G$2:$G$121,$C$2:$C$121,04) April 4 96 =AVERAGE(D5,017,029,041,053,065,077, D89,D101,D113) =E5/AVERAGE(SE$2:$E$13) =D5/F5 TREND($G$2:$G$121,$C$2:$c$121,6) May 5 195 -AVERAGE(D6,018,D30,042,D54,D66,078, D90, D102,D114) =E6/AVERAGE($E$2:$E$13) =D6/F6 -TREND($G$2:$G$121,$C$2:$C$121,06) June 6 115 AVERAGE(D7,019,031,043,055,067,079, D91,D103,D115) =E7/AVERAGE(SE$2:$E$13) -D7/F7 TRENDISG$2:$G$121,$C$2:$C$121,c7) July 7 107 =AVERAGE(D8,020,032,044,D56,068,080, D92,D104,D116) =E8/AVERAGE(SE$2:$E$13) =D8/F8 -TREND($G$2:$G$121,$C$2:$C$121,08) August 8 104 =AVERAGE(D9,021,033,045,D57,069,081, D93,D105,D117) = 9/AVERAGE(SE$2:$E$13) =D9/P9 TREND($G$2:$G$121,$C$2:$C$121,09) September 9 96 AVERAGE(D10,022,034,046,058,070,082, D94,D106,D118) =E10/AVERAGE(SE$2:$E$13) =D10/F10 TREND($G$2:$G$121,$C$2:$C$121,010) October 10 112 =AVERAGE(D11,023,035,047,059,071,083, D95,D107,D119) =E11/AVERAGE(SE$2:$E$13) =D11/F11 TREND($G$2:$G$121,$C$2:$C$121,011) November (11 98 =AVERAGE(012,024,036,048,060,072,084, 196,0108,0120) =E12/AVERAGE($E$2:$E$13) =D12/F12 =TREND($G$2:$G$121,$C$2:$C$121,012) December 12 102 =AVERAGE(D13,025,037,049,061,073,085, D97,D109,D121) =E13/AVERAGE($E$2:$E$13) =D13/F13 ETREND($G$2:$G$121,$C$2:$C$121,013) January 13 104 =F2 =D14/F14 =TREND($G$2:$G$121,$C$2:$C$121,014) February 14 100 =F3 =D15/F15 TREND($G$2:$G$121,$C$2:$C$121,015) March 15 199 =14 =D16/F16 -TREND(SG$2:$G$121,$C$2:$C$121,016) April 16 88 =F5 =D17/F17 TRENDISG$2:$G$121,$C$2:$C$121,017) | May 17 89 -F6 -D18/F18 TREND($G$2:$G$121,$C$2:$C$121,018) June 18 108 F7 -D19/F19 TREND($G$2:$G$121,$C$2:$C$121,C19) July 19 109 =F8 =D20/F20 TREND(SG$2:$G$121,$C$2:$C$121,0201 Seasonal Forecast =H2F2 =H313 =H4*F4 HS F5 H6 F6 H7*F7 H8*F8 =H9*F9 H10*F10 EH11 F11 =H12*F12 EH13 F13 =H14*F14 H15*15 =H16*F16 H17*F17 H18*F18 H19*F19 =H20* F20

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!