I need help figuring out null and alternative hypotheses in excel.

Price: $10 USD

Question description

I have the data set already and I have the megastats add-in installed. Please let me know if you can help me with this. 

  1. If Springdale Mall offered exactly the same benefits as the other two shopping areas, we would expect exactly one-third of those who expressed an opinion to select it as the area best fitting the description for variable number 10 (“Easy to return/exchange goods”). In testing whether Springdale Mall differs significantly from this expected proportion, the null and alternative hypotheses will be H0: π = 0.333 and H1: π ≠ 0.333. Carry out the following analyses for Springdale Mall:
    1. Analyzing the data for variable 10, use the preceding null and alternative hypotheses in testing the null hypothesis at the 0.05 level.
    2. Determine the p-value for the test conducted in part (a).

Tutor Answer

(Top Tutor) Daniel C.
School: UC Berkeley
Studypool has helped 1,244,100 students
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1829 tutors are online

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors