Homework #14- Excel Illustration #3
pdf
keyboard_arrow_up
School
Miami University *
*We aren’t endorsed by this school
Course
MISC
Subject
Information Systems
Date
Feb 20, 2024
Type
Pages
3
Uploaded by ChiefBearMaster1005
First and Last Name: _________________________________ Date: ___________________ Homework #14: Excel Illustration #3 Instructions You will turn in only one Excel document. The Excel document should be entitled as “Last Name, First Name_Homework #14”
. For questions 2-7, you should use a different worksheet within one Excel document and name each worksheet according to each question. For help on how to produce different worksheets in one Excel file, see the following: https://www.youtube.com/watch?v=oRpHLKZyj5w Chapter 1- Section 1-5 1.
Explore Microsoft Excel and the various ways to use built-in functions to solve statistical problems. The best way to start this process is to add Excel’s Analysis Tool Pak Add-In. The use of Excel and the add-in will assist you with future statistical calculations. You can find directions on how to add the “Add-In” in Section 1-5 of Chapter 1 or via https://support.microsoft.com/en-us/office/use-the-analysis-toolpak-to-perform-complex-
data-analysis-6c67ccf0-f4a9-487c-8dec-bdb5a2cefab6 Chapter 7 2.
Using Microsoft Excel, you will construct a Confidence Interval for a Sample based upon the t Distribution
by following each step provided in the following YouTube video: https://www.youtube.com/watch?v=FedZLuhk8A4 You will use the following distribution data at a 95% and 99% confidence interval: 19, 15, 20, 25, 30, 14, 13, 12, 18, 21, 24, 22, 14, 15, 38 *Make sure you rename this worksheet, “Question #2” 3.
Using Microsoft Excel, you will construct a Confidence Interval for a Sample based upon the t Distribution
by following each step provided in the following YouTube video: https://www.youtube.com/watch?v=FedZLuhk8A4 You will use the following distribution data at a 90% and 95% confidence interval: 579, 575, 577, 575, 570, 574, 573, 572, 578, 571 *Make sure you rename this worksheet, “Question #3”
2 Chapter 8 4.
Using Microsoft Excel, you will construct a One-Sample Hypothesis z-test for the Mean
by following each step provided in the following YouTube video (0:42 – 2:35): https://www.youtube.com/watch?v=xQjGXP0JNB8 You will use the following distribution data in pounds: 139, 145, 120, 155, 140, 144, 153, 132, 138, 141, 124 Standard Deviation (σ): 3 Variance (σ
2
): 9 a
= 0.05 H
0
: μ
= 135 H
1
: μ
≠ 135 *Make sure you rename this worksheet, “Question #4” 5.
Using Microsoft Excel, you will construct a One-Sample Hypothesis z-test for the Mean
by following each step provided in the following YouTube video (0:42 – 2:35): https://www.youtube.com/watch?v=xQjGXP0JNB8 You will use the following distribution data in pounds: 98, 87, 94, 85, 90, 84, 89, 95, 92, 91, 88, 87 Standard Deviation (σ): 2 Variance (σ
2
): 4 a
= 0.01 H
0
: μ
= 88 H
1
: μ
≠ 88 *Make sure you rename this worksheet, “Question #5” 6.
Using Microsoft Excel, you will construct a One-Sample Hypothesis t-test for the Mean
by following each step provided in the following YouTube video (0:40 – 2:31): https://www.youtube.com/watch?v=v-ZcqrdTcIQ You will use the following distribution data in inches: 54, 55, 49, 53, 54, 59, 50, 52, 58, 61, 57, 51
3 a
= 0.05 H0: μ
≤
53 H1: μ
>
53
*Make sure you rename this worksheet, “Question #6” 7.
Using Microsoft Excel, you will construct a One-Sample Hypothesis t-test for the Mean
by following each step provided in the following YouTube video (0:40 – 2:31): https://www.youtube.com/watch?v=v-ZcqrdTcIQ You will use the following distribution data in inches: 833, 825, 819, 823, 814, 829, 820, 812, 818, 831, 827, 811 a
= 0.05 H0: μ
≤
820 H1: μ
>
820
*Make sure you rename this worksheet, “Question #7”
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help