Question
Date Amgen Date 222.78 Date 228.15 Date 228.90 Date 233.28 Date 232.38 Date 231.42 Date 232.54 Date 236.38 Date 240.12 Date 242.84 Date 246.84 Date
Date Amgen Date 222.78 Date 228.15 Date 228.90 Date 233.28 Date 232.38 Date 231.42 Date 232.54 Date 236.38 Date 240.12 Date 242.84 Date 246.84 Date 246.52 Date 247.96 Date 251.48 Date 252.95 Date 245.57 Date 242.33 Date 236.15 Date 235.17 Date 235.23 Date 231.90 Date 232.03 Date 231.15 Date 232.38 Date 231.48 Date 233.25 Date 231.61 Date 233.75 Date 229.44 Date 232.17 Date 229.14 Date 228.31 Date 228.09 Date 229.07 Date 226.63 Date 224.20 Date 221.64 Date 223.73 Date 222.40 Date 220.67 Date 218.67 Date 224.41 Date 224.49 Date 225.65 Date 226.60 Date 227.80 Date 227.00 Date 232.52 Date 236.81 Date 240.71 Date 240.85 Date 242.35 Date 246.05 Date 241.46 Date 241.89 Date 242.66 3/26/2021 249.17 3/29/2021 251.24 3/30/2021 246.11 3/31/2021 245.18 4/1/2021 245.53 4/5/2021 248.34 4/6/2021 245.47 4/7/2021 244.50 4/8/2021 243.28 4/9/2021 245.32 4/12/2021 245.31 4/13/2021 246.30 4/14/2021 245.98 4/15/2021 251.41 4/16/2021 251.98 4/19/2021 252.24 4/20/2021 255.36 4/21/2021 255.00 4/22/2021 251.33 4/23/2021 253.28 4/26/2021 251.79 4/27/2021 251.41 4/28/2021 233.26 4/29/2021 231.29 4/30/2021 236.14 5/3/2021 241.80 5/4/2021 243.75 5/5/2021 245.71 5/6/2021 247.63 5/7/2021 250.50 5/10/2021 248.93 5/11/2021 248.62 5/12/2021 247.17 5/13/2021 248.39 5/14/2021 249.45 5/17/2021 250.45 5/18/2021 248.94 5/19/2021 246.72 5/20/2021 250.00 5/21/2021 249.09 5/24/2021 245.85 5/25/2021 240.15 5/26/2021 236.72 5/27/2021 233.51 5/28/2021 236.12 6/1/2021 231.79 6/2/2021 233.36 6/3/2021 233.93 6/4/2021 235.04 6/7/2021 235.37 6/8/2021 235.01 6/9/2021 237.68 6/10/2021 242.77 6/11/2021 240.91 6/14/2021 239.34 6/15/2021 238.01 6/16/2021 237.74 6/17/2021 238.92 6/18/2021 236.85 6/21/2021 238.40 6/22/2021 238.07 6/23/2021 236.88 6/24/2021 239.10 6/25/2021 240.82 6/28/2021 240.98 6/29/2021 240.60 6/30/2021 241.88 7/1/2021 245.01 7/2/2021 246.79 7/6/2021 241.78 7/7/2021 241.36 7/8/2021 242.41 7/9/2021 243.32 7/12/2021 242.50 7/13/2021 242.95 7/14/2021 242.82 7/15/2021 244.74 7/16/2021 246.06 7/19/2021 244.84 7/20/2021 245.00 7/21/2021 242.97 7/22/2021 242.86 7/23/2021 245.82 7/26/2021 243.20 7/27/2021 242.81 7/28/2021 242.38 7/29/2021 240.60 7/30/2021 239.69 8/2/2021 237.95 8/3/2021 242.21 8/4/2021 226.56 8/5/2021 232.20 8/6/2021 228.39 8/9/2021 226.14 8/10/2021 226.21 8/11/2021 226.38 8/12/2021 226.40 8/13/2021 227.92 8/16/2021 231.07 8/17/2021 231.20 8/18/2021 226.84 8/19/2021 224.39 8/20/2021 223.53
Problem #1: (10 Points for calculation)
In this problem, I am asking you to use SAS coding to provide for me an ANOVA analysis using the three companies. In addition to the SAS Code, please explain for me why we are using an ANOVA test and what we are trying to compare. Also tell me which of the three, if any, is not the same with the rest.
Points will be deducted if you do not understand why and how to do this analysis.
Problem #2: (10 Points for calculation)
In this problem, you must provide for me a Linear Regression analysis using the three companies. Please use your company as the dependent variable and the other two companies as the independent variables. You can perform a forward or backward analysis. In addition to the SAS Code, please explain for me what the results mean.
Points will be deducted if you do not understand why and how to do this analysis.
Problem #3: (10 Points for calculation)
In this problem, you must provide for me three Forecasting methods: Simple Moving Average Single and Double Exponent Smoothing Methods. You also need to provide for me the calculation of one Error calculation. In addition to the SAS Code, please explain for me what method is the best based on the three methods I have asked you to perform..
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started