A phone company plans on offering their new smartphone in four colours: white, black, silver and rose gold. They anticipate that 30% of shoppers will prefer white, 35% will prefer black, 20% will...

A phone company plans on offering their new smartphone in four colours: white, black, silver and rose gold. They anticipate

that 30% of shoppers will prefer white, 35% will prefer black, 20% will prefer silver and 15% will prefer rose gold. They

perform market research by asking a random sample 350 potential customers which colour they prefer.



Colour White Black Silver Rose Gold
Frequency 100 130 85 35


Can the company conclude that their observed frequencies are consistent with the expected distribution at a 5% level of significance?

*Please provide calculation using excel functions and in a step by step manner to give me understaning thank  you in advance.