The executives at a national retailer wish to examine whether there is any signi

Question

The executives at a national retailer wish to examine whether there is any significant difference in the mean sales performance across its branch offices. Monthly sales totals (in dollars) were collected for 31 randomly elected sales representatives from each of four branch offices (Costal, Lakeside, Gulfview, Rockies). (D) The executives would like to demote the manager of the branch office with the lowest mean sales. Can you identify this office? If so, conduct an appropriate analysis and explain your answer. If not, explain why not.

$9,822.00

Branch Coastal Lakeside Gulfview Rockies $7,777.00 $9,635.00 $11,135.00 $8,955.00 $9,756.00 $19,672.00 $9,078.00 $9,335.00 $4,295.00 $10,064.00 $10,627.00 $11,515.00 $9,134.00 $10,441.00 $10,673.00 $9,626.00 $5,312.00 $8,520.00 $8,979.00 $9,215.00 $9,448.00 $9,954.00 $7,311.00 $11,123.00 $9,877.00 $12,480.00 $10,738.00 $9,962.00 $7,880.00 $9,596.00 $11,860.00 $11,180.00 $8,232.00 $9,653.00 $11,045.00 $9,392.00 $10,426.00 $9,792.00 $9,848.00 $10,859.00 $11,538.00 $9,602.00 $9,885.00 $10,786.00 $9,469.00 $19,270.00 $9,509.00 $8,747.00 $10,080.00 $10,685.00 $8,635.00 $9,776.00 $9,885.00 $10,486.00 $7,159.00 $9,646.00 $9,162.00 $8,818.00 $10,609.00 $11,047.00 $10,832.00 $10,363.00 $9,067.00 $10,558.00 $6,580.00 $15,029.00 $8,644.00 $9,491.00 $8,714.00 $9,907.00 $10,437.00 $10,145.00 $9,313.00 $19,038.00 $10,331.00 $10,593.00 $5,099.00 $9,977.00 $6,667.00 $9,860.00 $8,270.00 $10,002.00 $10,573.00 $7,574.00 $10,097.00 $10,334.00 $10,951.00 $6,356.00 $10,286.00 $9,474.00 $9,562.00 $11,223.00 $7,991.00 $9,738.00 $10,170.00 $9,083.00 $10,192.00 $9,040.00 $9,022.00 $9,590.00 $9,622.00 $9,762.00 $8,043.00 $10,779.00 $10,313.00 $11,090.00 $10,821.00 $9,737.00 $5,096.00 $11,560.00 $6,547.00 $8,864.00 $6,523.00 $11,456.00 $8,989.00 $7,845.00 $4,523.00 $12,569.00 $10,258.00 $9,563.00 $6,589.00 $10,258.00 $9,875.00

$9,822.00

Explanation / Answer

To find mean sales we add data for all columns then divide the sum by 31 as shown in table.

---------------------------------------------------------------------------------------------------------

We are getting least mean sales for Coastal office. Hence executives can demote the manager of the Coastal branch office.

Coastal Lakeside Gulfview Rockies 7777.00 9635.00 11135.00 8955.00 9756.00 19672.00 9078.00 9335.00 4295.00 10064.00 10627.00 11515.00 9134.00 10441.00 10673.00 9626.00 5312.00 8520.00 8979.00 9215.00 9448.00 9954.00 7311.00 11123.00 9877.00 12480.00 10738.00 9962.00 7880.00 9596.00 11860.00 11180.00 8232.00 9653.00 11045.00 9392.00 10426.00 9792.00 9848.00 10859.00 11538.00 9602.00 9885.00 10786.00 9469.00 19270.00 9509.00 8747.00 10080.00 10685.00 8635.00 9776.00 9885.00 10486.00 7159.00 9646.00 9162.00 8818.00 10609.00 11047.00 10832.00 10363.00 9067.00 10558.00 6580.00 15029.00 8644.00 9491.00 8714.00 9907.00 10437.00 10145.00 9313.00 19038.00 10331.00 10593.00 5099.00 9977.00 6667.00 9860.00 8270.00 10002.00 10573.00 7574.00 10097.00 10334.00 10951.00 6356.00 10286.00 9474.00 9562.00 11223.00 7991.00 9738.00 10170.00 9083.00 10192.00 9040.00 9022.00 9590.00 9622.00 9762.00 8043.00 10779.00 10313.00 11090.00 10821.00 9737.00 5096.00 11560.00 6547.00 8864.00 6523.00 11456.00 8989.00 7845.00 4523.00 12569.00 10258.00 9563.00 6589.00 10258.00 9875.00 9822.00 SUM= 262311.00 348265.00 297048.00 302247.00 MEAN SALES= 8461.645161 11234.35484 9582.193548 9749.903226 Least Mean = 8461.645161

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.