Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Unit I: Summarizing Data Using Measures of Center and Measures of Spread [Excel 2111!! & 29971 Open a new Excel worksheet (which will be saved
Unit I: Summarizing Data Using Measures of Center and Measures of Spread [Excel 2111!! & 29971 Open a new Excel worksheet (which will be saved as MEASURES.xlsx). In cell A1 type your name. In cell A2 type the course and section number (i.e. ECON225~001). In cell A3 type the date. Leave cell A4 blank. In cell A5 type \"Assignment: Summarizing Data Using Measures of Center and Measures of Spread\". In cell A6 type \"File: MEASURES.xlsx\". Copy the 25 data values entered in Assignment #1: CHARTS.xlsx and paste them in column E, cells E8 through E32. (If you did not do Excel Assignment #1, enter the 25 data values shown under point #2 of Assignment #1 in cells E8 through E32. Check the numbers to make sure they were correctly entered.) 3. Click on the Data tab in the toolbar. Select Data Analysis, then select Descriptive Statistics. Click on OK. (Note: If you do not have \"Data Analysis\" available, follow the directions in the Excel Getting Started Instructions.) In the Input Range type E8:E32. Under the Output options click on Output Range and type B8. Also click on Summary statistics (If any of the other output options are selected, remove the dot or check by clicking on it.) Click on OK. Position the mouse cross marker between the \"B\" and \"C\" worksheet column headings. The shape of the cross marker should change. Hold down the left mouse button and slowly move the column width to the right until the names of all of the Summary Measures in the table are fully visible. Next, position the mouse cross marker between the \"C\" and \"D\" worksheet column headings. Slowly move this column width to the right until every printed summary number is fully visible. Save your worksheet on a disk as MEASURES.xlsx and print-out the worksheet to submit to the instructor
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