Math 175 Intro Statistics Project 2 A city planner claims that a traffic light at a particular intersection was necessary, and installing it decreased the wait time for right turns. At each of the...

Just have to complete this excel project there is no MLA stuff like that


Math 175 Intro Statistics Project 2 A city planner claims that a traffic light at a particular intersection was necessary, and installing it decreased the wait time for right turns. At each of the hours during a 24 hour period, she records the wait time in seconds before and after the traffic light was installed. Construct the appropriate null and alternative hypotheses by hand. Use Excel to enter “time headings” in cell a1, “seconds before” in cell b1, “seconds after” in cell c1, “difference: before - after” in cell d1, and “increase/decrease” in cell e1. Starting with cell a2, enter the times of day (12 am, and so on) consecutively. Starting with cell b2, enter the wait in seconds (10, and so on) before the traffic light. Starting with cell c2, enter the wait in seconds (23, and so on) after the traffic light. Starting with cell d2, enter the difference in seconds, after - before (13, and so on). To do this, construct a formula for after – before, recalling that = should precede all excel formulas. Starting with cell e2, enter whether there is an increase or decrease (increase, and so on). Use data >> data analysis >> t-test: paired differences for two means. Place this information in cell g2. (If the data analysis package needs to be loaded, then file>>options>>add-ins>>go>>analysis toolpak) List the test statistic TS=t=______________. List the critical value CV=______________. List the appropriate P-value = ___________. Determine whether to support or reject the claim at the significance level. If some commuters stated that their wait time has increased, what information would be relevant to ask them? Time BeforeTime After 12 am1023 1 am922 2 am821 3 am1027 4 am1524 5 am1928 6 am2327 7 am6738 8 am5637 9 am4234 10 am3423 11 am3927 12 pm4831 1 pm4529 2 pm3228 3 pm2321 4 pm6047 5 pm7842 6 pm5139 7 pm4923 8 pm2622 9 pm1723 10 pm922 11 pm821 0.1 a =