Answered step by step
Verified Expert Solution
Question
1 Approved Answer
using excel for these two problems thank you! A. Obtain the linear trend equation (first, plot the data and the regression line on the same
using excel for these two problems thank you! A. Obtain the linear trend equation (first, plot the data and the regression line on the same graph, or alternatively use Data Analysis tool to obtain the " a " and the " b " values of the equation) for the following data on new checking accounts for Fair Savings Bank and use it to predict expected new checking accounts for periods 15 through 20. Enter the data on Excel using Period (X) as Column 1 and New Accounts (Y) in the second column. B. Determine the correlation coefficient and interpret it. C. What percentage of variation in new accounts is explained by the independent variable (time)? 43. Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 months. The forecasts and actual sales are as follows: REQUIRED: Compute the MAD and MSE for each forecast. Does either forecast seem superior? Explain
using excel for these two problems thank you!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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