store #	units sold
001	8,326
002	2,741
003	10,537
004	3,114
005	4,463
006	6,449
007	3,133
008	6,619
009	4,132
010	4,518
011	4,962
012	4,948
013	5,437
014	4,201
015	2,247
016	6,200
017	3,640
018	6,408
019	7,320
020	2,880
021	5,058
022	4,962
023	5,268
024	5,164
025	4,238
026	10,395
027	4,395
028	5,386
029	7,428
030	8,426
031	5,585
032	6,506
033	2,950
034	4,570
035	9,522
036	5,277
037	6,005
038	5,720
039	2,873
040	8,544
041	3,601
042	5,140
043	4,109
044	8,899
045	3,970
046	8,060
047	3,949
048	5,252
049	2,924
050	8,312
051	8,503
052	4,471
053	3,491
054	5,344
055	9,580
056	9,875
057	7,228
058	5,388
059	2,807
060	5,140
061	4,584
062	3,393
063	9,287
064	6,526
065	3,265
066	3,554
067	5,263
068	3,890
069	3,581
070	7,548
071	4,166
072	4,269
073	1,916
074	2,062
075	3,754
076	4,076
077	4,012
078	7,137
079	8,224
080	6,653
081	3,016
082	4,956
083	4,310
084	2,855
085	9,367
086	8,315
087	3,474
088	4,099
089	4,587
090	3,927
091	3,059
092	2,913
093	8,284
094	5,142

using the folowing data in excel

find

1a. State the null and alternative hypotheses.

1b. What is the sample proportion of respondents who overall preferred the new dispenser cap? (Round your answer to three decimal places.)

1c. What is the standard error of the sampling distribution? (Round your answer to four decimal places.)

1d. What is the value of the test statistic? (Round your answer to two decimal places.)

1e.What is the p-value? (Round your answer to four decimal places.)