Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Your classmates were invited to complete a MATH 1P98 student survey. The amount of sleep that 290 students reported they got on a typical weeknight

image text in transcribed
Your classmates were invited to complete a MATH 1P98 student survey. The amount of sleep that 290 students reported they got on a typical weeknight are given in the Excel sheet. 1. The first step in preparing the data is to identify any values that should be removed from our analysis. The data was collected in hh:mm form. (For example, 8:15 corresponds to 8 hours 15 minutes.) a. (Nothing to submit.) Optional step: Create a copy of the sheet on Excel. . Right click on the bottom sheet tab and then click Move or copy. In the dialog box, select the sheet you want to copy, check the box Create a copy, and click OK. . Note: By working on a copied sheet, the original data remains available in a separate sheet for later use, if needed. b. (Nothing to submit.) Use Excel to sort the sleep data in ascending order. . Select all cells in the header. In this sheet, you would select cells Al to C1. . Click the Data tab in the top menu and click Filter. . Click the triangle filter beside the header called Sleep and click Sort Smallest to Largest. c. (Submit a screenshot of your written or typed answer.) Examine the sorted times, paying close attention to the data listed at extreme ends of the list. Identify the two sleep times that should be removed from the analysis and provide a justification of each removal. d. (Nothing to submit.) On the Excel sheet, delete the rows of survey data for the observations you identified in part c. Hint: You should have 288 observations remaining

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

Partial Differential Equations With Fourier Series And Boundary Value Problems

Authors: Nakhle H Asmar

1st Edition

0486820831, 9780486820835

More Books

Students also viewed these Mathematics questions

Question

=+b) Are the conditions for two-way ANOVA met?

Answered: 1 week ago