A sales region has been divided into five territories, each of which was believed to have equal sales potential.The actual Sales Volume for several sampled days is logged in the data below.At a = 0.05, do the territories have equal Sales Volume?

A B C D E

SALES VOLUME 110140 100 106 110

Whichanswer below is the best fit?

A) H0:Territories have equal SalesVolume is rejected with pvalue 0.041.The counts are not consistent with the model of equal proportions.Territories have unequal SalesVolume.

B) H0: Territories have equal Sales Volume is not rejected with pvalue 0.074.The counts are consistent with the model of equal proportions.

C) None of the answers are correct.

D) H0: Territories have equal Sales Volume is not rejected with pvalue 0.334.the counts are consistent with the model of equal proportions.

E) H0:Territories have equal Sales Volume is rejected with pvalue 0.012.The counts are not consistent with the model of equal proportions.Territories have unequal sales volume.

I got B) H0: Territories have equal Sales Volume is not rejected with pvalue 0.074.The counts are consistent with the model of equal proportions. for my answer, is that correct, can you show the way to get this answer on excel? Thanks