Answered step by step
Verified Expert Solution
Link Copied!

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

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

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

Physics For Scientists And Engineers

Authors: Raymond A Serway, John W Jewett

10th Edition

1337671711, 9781337671712

More Books

Students also viewed these Mathematics questions

Question

a sin(2x) x Let f(x)=2x+1 In(be)

Answered: 1 week ago