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 2911! Q 2111!?) 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 2911! Q 2111!?) 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. ECON225001). 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 BB. 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

Essential Discrete Mathematics For Computer Science

Authors: Harry Lewis, Rachel Zax

1st Edition

0691190615, 9780691190617

More Books

Students also viewed these Mathematics questions

Question

What are the limitations of activity-based costing? AppendixLO1

Answered: 1 week ago

Question

=+c) Does this model improve on the model in Exercise 18? Explain.

Answered: 1 week ago

Question

What is meant by planning or define planning?

Answered: 1 week ago

Question

Define span of management or define span of control ?

Answered: 1 week ago

Question

What is meant by formal organisation ?

Answered: 1 week ago

Question

What is meant by staff authority ?

Answered: 1 week ago

Question

4. What means will you use to achieve these values?

Answered: 1 week ago

Question

3. What values would you say are your core values?

Answered: 1 week ago