Question

fe Sub 105 195 120 105 90 120 45 140 00 80 100-07 06-os 104 103 02 101 100 99 98 97 96 95 94 93 D 5-0-5 789 0 i 2 3 4 5 16 17 18 19 20 21 22 24 234 6 26 28 -B art 1234|1234123412 3 4 1 2 3 | 41234|1|234 ▲ ▼ 555566667777 A ca-i i i 2 2 2 2 3 3 3 3 4 4 4 4 0123456789 5 6 7 8 9 10 1 11
media%2F502%2F50239a04-0457-4bfe-90e2-77
0 0
Add a comment Improve this question Transcribed image text
Answer #1

we enter the data in excel and perform the analysis as shown below

we goto dat > data analysis tab and select exponential smoothing

Review View Tell me what you want to do... Z A Sort Filter File Home Insert Page Layout Formulas Data Show Queries 2l Connections Properties Clear A Consolidate Relationships Manage Data Model Flash Fill From Table B-E Remove Duplicates t External New DataQuery Refresh Lo Recent Socs All Edit Links Columns E Data Validation What-If F Analysis Get & Transform Connections Sort & Filter Data Tools Foreca 4 Month Sales ЗМА 4MA alpha 0.1 a Data Analysis 23 105 135 1 Analysis Tools OK Anova: Single Factor Anova: Two-Factor With Replication Anova: Two-Factor Without Replication Correlation Covariance Descriptive Statistics Exponential Smoothin F-Test Two-Sample for Variances Fourier Analysis Histogram Cancel 4 105 120 116.25 105112.5 105108.75 115 135 123.75 80 128.3333 126.25 100 106.6667 116.25 105 97.5 99.25 105 107.6667105.75 Help 145 140 118.3333 100 10 12 13 14 110 93.33333 107 96.66667 106 105.6667 106

Please note that we can answer only 4 subparts of a quesiton at a time , as per the answering guidleines

Add a comment
Know the answer?
Add Answer to:
fe Sub 105 195 120 105 90 120 45 140 00 80 100-07 06-os 104 103...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 1.         For each set below, using Excel, construct            a.         a frequency distribution,   ...

    1.         For each set below, using Excel, construct            a.         a frequency distribution,    b.         a relative frequency distribution, and            c.         a cumulative relative frequency distribution. Consider whether or not you should group your data. Describe how you determined your bin width, if you grouped the data in intervals. Set 1 75    95    103 100 93 91 90 92 89 105 86 85 81 96 103 99 94 95 91 97 92 107...

  • Here is your (discrete) data 108 83 93 118 88 58 88 65 113 103 119...

    Here is your (discrete) data 108 83 93 118 88 58 88 65 113 103 119 101 91 92 95 86 85 73 94 61 121 71 116 78 114 119 118 131 41 70 68 98 202 155 41 93 78 96 93 110 100 61 98 39 94 86 108 75 64 50 90 123 109 69 118 85 102 86 153 109 89 134 80 104 96 129 48 81 102 31 97 130 98 105 109...

  • Consider the applications for home mortgages data in the file of P12_04.xlsx. Create a time series...

    Consider the applications for home mortgages data in the file of P12_04.xlsx. Create a time series chart of the dat Use simple exponential smoothing to forecast these data, using the default smoothing constant of 0.1 Calculate the three types of forecast errors, RMSE, MAE, and MAPE Use the solver function in excel to optimize the smoothing constant in order to generate a minimum MAPE value. Use multiple regression to develop an equation that can be used to predict future applications...

  • Instructions Read each scenario in the document below and answer the questions. When you have completed...

    Instructions Read each scenario in the document below and answer the questions. When you have completed all scenarios, save the document with your last name in the file (ex: Hoernemann Module 13 Quality Control Assignment) and submit as an attachment to the appropriate assignment folder. Some scenarios require you to perform quality control calculations – you may use an Excel spreadsheet to perform the math but must include the spreadsheets with your submission for this assignment to receive full credit!...

  • Final Project For this assignment, use data from W1 Assignment. Using Minitab. Give instructions on how...

    Final Project For this assignment, use data from W1 Assignment. Using Minitab. Give instructions on how to insert data into Minitab. This week, you will explore the hypothesis that higher levels of stress are associated with lower levels of confidence. Compute the correlation between the stress score and confidence scores. StressScore   Confidence 3   100 5   112 2   125 9   150 7   136 4   107 3   143 1   141 4   134 2   148 5   139 3   117 7   76 8   99...

  • 7. (a) (15 pts.) With Figure 1 below showing shifts A and B, fill in the blank Table 1 showing the computation of the...

    7. (a) (15 pts.) With Figure 1 below showing shifts A and B, fill in the blank Table 1 showing the computation of the fraction of Bin Hours in each shift for the different time groups. VI V IV Group 1 A 9-12 13-16 17-20 21-24 Sunday Monday Tuesday Wednesday B B Thursday Friday Saturday Figure 1 Table 1 Computation of Fraction of Bin Hours in Each Shift Days Total in Shift A Fraction in Each Shift B Fraction in...

  • Please help in answering these questions: 1 Line 92 deck is a calling parameter. The received...

    Please help in answering these questions: 1 Line 92 deck is a calling parameter. The received number of that parameter is what? copy of original value pointer 2 Line 92, src is a calling parameter. The received number of that parameter is what? copy of original value pointer 3 Line 95 is a debugging technique where the computer prints what it is doing. Give the line number of a similar line in the example 99 101 108 113 4 Line...

  • Download the hypothesis testing dataset from the class website. 1. This is case 1, in which...

    Download the hypothesis testing dataset from the class website. 1. This is case 1, in which the value of population standard deviation is assumed to be known. a. Compute the standard deviation of the textbook price and assume this to be the population standard deviation. Type this value in E5. b. Pick a random sample of size 15. c. Compute the mean of your random sample in E4 using the AVERAGE function. d. Calculate the standard error in cell E9...

  • Infinite Spiral of Numbers (due 17 Feb 2020) HELLO, WE ARE USING PYTHON 3 TO COMPLETE...

    Infinite Spiral of Numbers (due 17 Feb 2020) HELLO, WE ARE USING PYTHON 3 TO COMPLETE THIS PROJECT!! PLEASE FOLLOW CODE SKELETON AS GIVEN AT THE END. THIS IS DUE 17TH FEB 2020, ANY AND ALL HELP WOULD BE GREATLY APPRECIATED, THANK YOU! Consider the natural numbers laid out in a square spiral, with 1 occupying the center of the spiral. The central 11 x 11 subset of that spiral is shown in the table below. 111 112 113 114...

  • 1. Forecast demand for Year 4. a. Explain what technique you utilized to forecast your demand....

    1. Forecast demand for Year 4. a. Explain what technique you utilized to forecast your demand. b. Explain why you chose this technique over others. Year 3 Year 1 Year 2 Actual Actual Actual Forecast Forecast Forecast Demand Demand Demand Week 1 52 57 63 55 66 77 Week 2 49 58 68 69 75 65 Week 3 47 50 58 65 80 74 Week 4 60 53 58 55 78 67 57 Week 5 49 57 64 76 77...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT