Convert the sales revenues figures into z-scores for each store location: “front
ID: 3216500 • Letter: C
Question
Convert the sales revenues figures into z-scores for each store location: “front of the store” and “in the aisle of the store,” and identify which times are considered unusual according the approach “Z-Scores and Unusual Observations.” Please show your output (include a snapshot of your excel analysis with clear labels) and include a sentence or two on whether any are considered unusual.
Front of the store Aisle of the store 224 192 189 236 248 164 285 154 273 189 190 220 243 261 215 186 280 219 317 202Explanation / Answer
As a general rule ,z scores lower than -1.96 or higher than 1.96 are considered outliers.
no outliers seen
Front of the store mean stddev Z front of the stor Aisle of the store mean tddev Z Aisle of the store 224 246.4 45.54201 -0.49185357 192 202.3 32.52708 -0.31665923 189 246.4 45.54201 -1.26037476 236 202.3 32.52708 1.0360598 248 246.4 45.54201 0.035132398 164 202.3 32.52708 -1.17748043 285 246.4 45.54201 0.847569091 154 202.3 32.52708 -1.48491657 273 246.4 45.54201 0.584076109 189 202.3 32.52708 -0.40889007 190 246.4 45.54201 -1.23841701 220 202.3 32.52708 0.544161972 243 246.4 45.54201 -0.07465634 261 202.3 32.52708 1.804650156 215 246.4 45.54201 -0.6894733 186 202.3 32.52708 -0.50112091 280 246.4 45.54201 0.737780348 219 202.3 32.52708 0.513418358 317 246.4 45.54201 1.550217041 202 202.3 32.52708 -0.00922308 average 246.4 202.3 202.3 32.52708 stddev 42.54200539 32.52708273