Question
Please use exel. Thank You in advance! Paired sample t test for 11.47, 11.49 for 11.47 1.) click on excel and enter data on the
Please use exel. Thank You in advance!
Paired sample t test for 11.47, 11.49 for 11.47 1.) click on excel and enter data on the worksheet. Enter data before treatment in cell range A1:A10. Enter data for after treatment in cell range 81:810. 2.) after clicking data analysis, click paired sample t test for two means. 3.) click ok 4.) enter data A1:A10 for variable input range 1. Enter data 81:810 for input range 2. Enter 0 for mean difference. 5.) deselect (unclick) labels. 6.) to list the output on a separate page, type paired sample t test in new worksheet ply. Click file, click ok For prob. 11.49, follow the same procedure. T test for the difference between 2 means, assuming equal variance. 1.) on the excel worksheet, enter the data for problem 11.10. in column 1, enter the data for sample 1 in cell range A1-A8. in column 2, enter the data for sample 2 in cell range 81:88. 2.) click data analysis. Click t test, assuming equal variance. 3.) in variable input range 1, enter A1:A8. In variable input range 2, enter B1:88. For mean difference, enter 0. By default, excel tests at the 5% level. Unclick labels. 4.) to present data on a separate page, if desired, enter equal variance t test in new worksheet ply. 5.) click file,click ok.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started