Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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!
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

A First Course In Probability

Authors: Sheldon Ross

10th Edition

0134753119, 978-0134753119

More Books

Students also viewed these Mathematics questions

Question

What is OXOs mission?

Answered: 1 week ago