Question

Convert the following sales revenues figures into z-scores for 2 store locations where products are located: “front of the store” and “in the aisle of the store,” and identify which revenues 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
113	132
114	134
105	119
125	167
98	129
106	115
147	130
116	152
102	134
128	121

You may assume that the population mean and population standard deviation are as follows:

Front of the store

μ = 115

σ = 15

Aisle of the store

μ = 133

σ = 16

Answer 1