National Scan, Inc, sells ratio frequency inventory tags. Monthly sales for a 6-
ID: 3156767 • Letter: N
Question
National Scan, Inc, sells ratio frequency inventory tags. Monthly sales for a 6-month period were as follows: Month: Disregard the demand pattern of the given time series, You are asked to use the time series to derive a trend equation In order to derive the trend equation is F_t = a + bt. you have to compute several components to compute the values for the variables a and b Answer the following questions pertaining to information that are relevant to deriving the trend equation The sigma ty The sigma y The value for the b (slope of the trend line) = (in 3 decimal places). The value for the a (intercept of the trend line) = (in 3 decimal places)Explanation / Answer
Sol)
c) The equation is
From Excel
slope=1.14
intercept=9.19
t y ty 2 11 22 3 13 39 4 13 52 5 17 85 6 15 90 7 17 119 sum= 86 407Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.