Asked by Bryan Flores on Jun 25, 2024

verifed

Verified

For the given data,what is the value of the root mean square error?

A) 600.33
B) 24.50
C) 21.67
D) 18.57

Root Mean Square Error

It is a measure used to assess the differences between values predicted by a model or an estimator and the observed values.

Sales Details

Specific information related to the sales transactions of a business, including quantities sold, prices, dates, and customer information.

Value of K

In statistics, it often represents a constant or a specific value in equations and formulas.

  • Discern and quantify assorted benchmarks of forecast reliability including root mean square error, mean absolute deviation, and mean absolute percentage error.
verifed

Verified Answer

AG
Ainsley GiangrossoJun 25, 2024
Final Answer :
B
Explanation :
The formula for calculating root mean square error (RMSE) is:
RMSE = sqrt(1/n * sum((actual - predicted)^2))
Using the given data and value of k=3, we can calculate the predicted sales for each day using a 3-day moving average.
The predicted sales for Day 4 would be: (100 + 120 + 130)/3 = 116.67
Using this method, the predicted sales and actual sales for each day, along with their difference squared, are as follows:

Day 1:
Actual Sales = 100
Predicted Sales = N/A (Not enough data for moving average)
Difference = N/A

Day 2:
Actual Sales = 120
Predicted Sales = N/A (Not enough data for moving average)
Difference = N/A

Day 3:
Actual Sales = 130
Predicted Sales = (100 + 120 + 130)/3 = 116.67
Difference = (130 - 116.67)^2 = 182.11

Day 4:
Actual Sales = 140
Predicted Sales = (120 + 130 + 140)/3 = 130
Difference = (140 - 130)^2 = 100

Day 5:
Actual Sales = 150
Predicted Sales = (130 + 140 + 150)/3 = 140
Difference = (150 - 140)^2 = 100

Day 6:
Actual Sales = 160
Predicted Sales = (140 + 150 + 160)/3 = 150
Difference = (160 - 150)^2 = 100

Using these values, we can calculate the sum of squared differences:
182.11 + 100 + 100 + 100 + 100 = 582.11
Then, we divide by the number of data points (n=5) and take the square root:
RMSE = sqrt(1/5 * 582.11) = 24.50, rounded to two decimal places.

Therefore, the best choice is B, with the explanation given above.