Ali Express - Excel Sign in X File Home Insert Page Layout Formulas Data Review View Developer Help Tell me what you want to do Share Insert Calibri 11 - A A = = = 2 4 29 Wrap Text Genera AY O Delete Sort & Find & Paste BIU- - A- Merge & Center % " Conditional Format as Cell Formatting * Table * Styles Format Filter ~ Select Cells Editing Clipboard Font Alignment Number Style H5 X fc 5050 RGB LED Strip Lights 5M-30M 2835 Led (5M) D G Document Recovery 1 Password Contact Number Payment |Date Time Order ID Product Name 2 kainat390 3476418996 2 PKR Nov. 17 2021 9:00 8142027159414389 Limei S1 E-Sports Luminous V Excel has recovered the following files. Save 3 Pakistaal1 3248523390 2 PKR Nov. 17 2021 3:50 8142142208412701 Led RGB Color Changing Lam the ones you wish to keep. 4 kainat160 3D Lamp Acrylic USB LED Nig 5 ameerhamza7222 3246873479 5050 RGB LED Strip Lights 5M-30N EXCELWITHIMAGE.xIsm [Or... X Version created last time the.. 2/7/2022 3:11 PM 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 ? Which file do I want to save? 35 Close Sheet1 + Average: 3246873479 Count: 3 Sum: 3246873479 100% Ready * Accessibility: Investigate 10:57 PM Type here to search O X 23"C Haze ^ 9 2 () ENG 2/9/2027Solution File [Protected View] - Excel Sign in X File Home Insert Page Layout Formulas Data Review View Developer Help Tell me what you want to do Share i PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X E41 X V B D G H I K M N R S T U W Exponential Smoothing Forecasting Method with Trend Exponential Range Name Cells Time True Latest Estimated Smoothing Forecasting Alpha 5 Period Valu Trend Trend Forecast Error Smoothing Constants Beta J7 6 24,015 0.00 24.000 EstimatedTrend E6:E35 25,203 7.50 3.75 24.011 1,192 Forecast F6:F35 mar 23,589 599.6 301.6 24,909 1,320 ForecastingError G6:G35 9 apr 27.45 -358.22 -28.27 24.221 3.233 Initial Estimates InitialEstimateAverage J10 10 may 1588.41 780.07 26.617 1,503 Average = 24,000 InitialEstimate Trend J11 jun 28,32 531.38 155.73 28,524 203 Trend: Latest Trend 06:035 july 29,02 054.01 1104.87 29.528 507 MAD J14 aug 6,95 85158 978 27 30,253 3,299 Mean Absolute Deviation MSE J17 sept 26,45 671.03 53.60 28.757 2,301 MAD = TrueValue C6:035 oct 27,120 396.83 21.62 27,185 nov 26,954 454.02 137.82 26,715 239 Mean Square Error dec 27.321 318.11 377.97 6,456 865 MSE = 3.929.602.9 26,45 54.37 161.80 26,727 27.45 297.23038 -230 26,362 1088 mar 31.435 314.52662 43 26,948 4.487 apr 33.12 2285.77 1164 30,35 2,768 36,000 - may 32,432 2548.2035 1856 33,596 1,164 31,90 1274 .1177 1565 34.579 34.000- july 2,678 226.04532 896 34.136 32.000 - 30.000 True Value 28,000 - -Forecast 28,000 24.000 22.000 20.000 3 11 15 17 18 Time Period Sheet1 Exponential with Trend Linear Regression Last Value + D Ready + 70% Type here to search O x e 23"C Haze ~ O () ENG 10:58 PM 2/9/202Solution File [Protected View] - Excel Sign in X File Home Insert Page Layout Formulas Data Review View Developer Help Tell me what you want to do Share i PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X E41 X V B D G H I K M N R S T U W Exponential Smoothing Forecasting Method with Trend Exponential Range Name Cells Time True Latest Estimated Smoothing Forecasting Alpha 5 Period Valu Trend Trend Forecast Error Smoothing Constants Beta J7 6 24,015 0.00 24.000 EstimatedTrend E6:E35 25,203 7.50 3.75 24.011 1,192 Forecast F6:F35 mar 23,589 599.6 301.6 24,909 1,320 ForecastingError G6:G35 9 apr 27.45 -358.22 -28.27 24.221 3.233 Initial Estimates InitialEstimateAverage J10 10 may 1588.41 780.07 26.617 1,503 Average = 24,000 InitialEstimate Trend J11 jun 28,32 531.38 155.73 28,524 203 Trend: Latest Trend 06:035 july 29,02 054.01 1104.87 29.528 507 MAD J14 aug 6,95 85158 978 27 30,253 3,299 Mean Absolute Deviation MSE J17 sept 26,45 671.03 53.60 28.757 2,301 MAD = TrueValue C6:035 oct 27,120 396.83 21.62 27,185 nov 26,954 454.02 137.82 26,715 239 Mean Square Error dec 27.321 318.11 377.97 6,456 865 MSE = 3.929.602.9 26,45 54.37 161.80 26,727 27.45 297.23038 -230 26,362 1088 mar 31.435 314.52662 43 26,948 4.487 apr 33.12 2285.77 1164 30,35 2,768 36,000 - may 32,432 2548.2035 1856 33,596 1,164 31,90 1274 .1177 1565 34.579 34.000- july 2,678 226.04532 896 34.136 32.000 - 30.000 True Value 28,000 - -Forecast 28,000 24.000 22.000 20.000 3 11 15 17 18 Time Period Sheet1 Exponential with Trend Linear Regression Last Value + D Ready + 70% Type here to search O x e 23"C Haze ~ O () ENG 10:58 PM 2/9/202The Following Data Are From A Completely Randomize... _ Chegg.com-converted [Protected View] - Excel Sign in X File Home Insert Page Layout Formulas Data Review View Developer Help Tell me what you want to do Share PROTECTED VIEW Be careful-files from the Internet can contain viruses, Unless you need to edit, it's safer to stay in Protected View. Enable Editing X A56 X F = MSTreatment / MSError = 67.58 B D E F G H I J K L M NA a) The following table show the group totals 2 a, G b, G2 c, G3 32 46 33 30 45 36 30 46 35 26 48 36 7 32 50 40 8 Total 150 235 180 And following table shows the grand total and total of square of observations: 10 11 G G12 12 32 1024 13 30 1900 14 30 900 15 26 676 16 32 1024 17 46 2116 18 15 2025 19 16 21 16 20 48 2304 21 50 22 2500 33 1089 23 36 24 1296 Table 1 Table 2 + D Ready + 100% Type here to search O 10:59 PM 23"C Haze ~ O () ENG 2/9/2022 F6The Following Data Are From A Completely Randomize... _ Chegg.com-converted [Protected View] - Excel Sign in X File Home Insert Page Layout Formulas Data Review View Developer Help Tell me what you want to do Share PROTECTED VIEW Be careful-files from the Internet can contain viruses, Unless you need to edit, it's safer to stay in Protected View. Enable Editing X A56 X fx F = MSTreatment / MSError = 67.58 B D E F G H I J K L M NA [G1=150, [G -235, _G:-180, n1 =5, n2=5, n3=5, [G=565, _G 22091 32 33 Now 34 35 SST = [ G:- (EG) 2 / N = 809.3 36 37 Now 38 39 SS Treatment = ([G.) 2 / n, + (EG:)? / n: + (EG:)2 / n: - ([G)? / N = 743.3 40 Now 41 42 SS Error = SST - SS Treatment = 66.00 43 14 Since there are 3 different groups so we have k=3. Therefore degree of freedoms are: If Treatment = k-1 = 3 - 1 = 2 f Error = N-k = 15 - 3 = 12 47 df Total = 12 + 2 = 14 48 Now 49 50 MS Treatment = SS Treatment | df Treatment = 371.7 51 52 Table 1 Table 2 + D Ready + 100% Type here to search O 10:59 PM 23"C Haze ^ O () ENG 2/9/2022 F6The Following Data Are From A Completely Randomize... _ Chegg.com-converted [Protected View] - Excel Sign in X File Home Insert Page Layout Formulas Data Review View Developer Help Tell me what you want to do Share PROTECTED VIEW Be careful-files from the Internet can contain viruses, Unless you need to edit, it's safer to stay in Protected View. Enable Editing X A56 X F = MSTreatment / MSError = 67.58 B D H I J K L M NA Critical value of t for level of significance 0.05 and degree of freedom of error is dfW = 12 is 2.179. 64 And we have 65 Since sample sizes are same so LSD will be 66 67 SS Error = S.ST - SSTreatment = 66.00 df Error = N - k = 15 - 3 = 12 dftotal = 12 + 2 = 14 74 MSTreatment = STreatment = 371.7 dfTreatment SSError MSError = 5.500 75 df Error MISTreatment - = 67.58 76 MSError MSW = MSError SSError = 5.500 78 dif Error 79 LSD = formal VMSW (4 + ) -2179 5.5 (6 + ;) -3.23 Absolute difference between sample mean A and sample mean B is : 17 80 Since absolute difference is greater than LSD so it is significant difference between groups A and B. 81 Absolute difference between sample mean A and sample mean C is : 6 82 Since absolute difference is greater than LSD so it is significant difference between groups A and C. 83 Absolute difference between sample mean B and sample mean C is : 11 84 Since absolute difference is greater than LSD so it is significant difference between groups B and C. 85 The 95% required confidence interval is: 86 0 Comments 87 88 89 Was this answer helpful? Table 1 Table 2 + Ready 100% Type here to search O x 10:59 PM 23"C Haze ~ O () ENG 2/9/2027 F6