Homework #4- Excel Illustration #1
pdf
keyboard_arrow_up
School
University of Alabama *
*We aren’t endorsed by this school
Course
345
Subject
Information Systems
Date
Feb 20, 2024
Type
Pages
3
Uploaded by ChiefBearMaster1005
First and Last Name: _________________________________ Date: ___________________ Homework #4: Excel Illustration #1 Instructions You will turn in only one Excel document. The Excel document should be entitled as “Last Name, First Name_Homework #4”
. For questions 2-14, 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 2- Section 2-1 2.
You will find the “Excel- Step by Step” section under the “Technology Step by Step” section in Chapter 2, Section 2-1. Using Microsoft Excel, you will complete the Categorical Frequency Table (Qualitative or Discrete Data)
by following each step. Make sure you rename this worksheet, “Question #2” 3.
You will find the “Excel- Step by Step” section under the “Technology Step by Step” section in Chapter 2, Section 2-1. Using Microsoft Excel, you will complete the Making a Grouped Frequency Distribution (Quantitative Data)
by following each step. Make sure you rename this worksheet, “Question #3” Chapter 2- Section 2-2 4.
You will find the “Excel- Step by Step” section under the “Technology Step by Step” section in Chapter 2, Section 2-2. Using Microsoft Excel, you will complete the Constructing a Histogram
by following each step. Make sure you rename this worksheet, “Question #4”
2 5.
You will find the “Excel- Step by Step” section under the “Technology Step by Step section in Chapter 2, Section 2-2. Using Microsoft Excel, you will complete the Constructing a Frequency Polygon
by following each step. Make sure you rename this worksheet, “Question #5” 6.
You will find the “Excel- Step by Step” section under the “Technology Step by Step” section in Chapter 2, Section 2-2. Using Microsoft Excel, you will complete the Constructing an Ogive
by following each step. Make sure you rename this worksheet, “Question #6” Chapter 2- Section 2-3 7.
You will find the “Excel- Step by Step” section under the “Technology Step by Step” section in Chapter 2, Section 2-3. Using Microsoft Excel, you will complete the Constructing a Pareto Chart
by following each step. Make sure you rename this worksheet, “Question #7” 8.
You will find the “Excel- Step by Step” section under the “Technology Step by Step” section in Chapter 2, Section 2-3. Using Microsoft Excel, you will complete the Constructing a Time Series Chart
by following each step. Make sure you rename this worksheet, “Question #8” 9.
You will find the “Excel- Step by Step” section under the “Technology Step by Step” section in Chapter 2, Section 2-3. Using Microsoft Excel, you will complete the Constructing a Pie Chart
by following each step. Make sure you rename this worksheet, “Question #9” Chapter 2- Section 2-4 10.
You will find the “Excel- Step by Step” section under the “Technology Step by Step” section in Chapter 2, Section 2-4. Using Microsoft Excel, you will complete the Constructing a Scatter Plot
by following each step. Make sure you rename this worksheet, “Question #10”
3 Chapter 3- Section 3-1 11.
You will find the “Excel- Step by Step” section under the “Technology Step by Step” section in Chapter 3, Section 3-1. Using Microsoft Excel, you will complete the Finding Measures of Central Tendency
by following each step. Make sure you rename this worksheet, “Question #11” Chapter 3- Section 3-2 12.
You will find the “Excel- Step by Step” section under the “Technology Step by Step” section in Chapter 3, Section 3-2. Using Microsoft Excel, you will complete the Finding Measures of Variation
by following each step. Make sure you rename this worksheet, “Question #12” Chapter 3- Section 3-3 13.
You will find the “Excel- Step by Step” section under the “Technology Step by Step” section in Chapter 3, Section 3-3. Using Microsoft Excel, you will complete the Finding Measures of Position
by following each step. Make sure you rename this worksheet, “Question #13” 14.
You will find the “Excel- Step by Step” section under the “Technology Step by Step” section in Chapter 3, Section 3-3. Using Microsoft Excel, you will complete the Descriptive Statistics
by following each step. Make sure you rename this worksheet, “Question #14”
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