Question: With the data set OSCR.XLS calculate the mean, median, standard deviation, variance, and range using Excel on its own tab. The functions to use are

6. Grooming Time Listed below are times (minutes) spent on hygiene and

grooming in the morn- ing (by randomly selected subjects) (based on data

With the data set OSCR.XLS calculate the mean, median, standard deviation, variance, and range using Excel on its own tab. The functions to use are AVERAGE, MEDIAN, STDEV.P, VAR.P, (range = MAX – MIN) for this problem.

6. Grooming Time Listed below are times (minutes) spent on hygiene and grooming in the morn- ing (by randomly selected subjects) (based on data from a Svenska Cellulosa Aktiebolaget survey). Construct a table representing the frequency distribution. Use the classes 0-9, 10-19, and so on. 0 5 12 15 15 20 22 24 25 25 25 27 27 28 30 30 35 35 40 45 ediye 200 7. Histogram of Grooming Times Use the frequency distribution from Exercise 6 to con- struct a histogram. Based on the result, do the data appear to be from a population with a normal distribution? Explain. oman ty pluon noilled

Step by Step Solution

★★★★★

3.33 Rating (165 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Calculate the mean median range and standard deviation of home price and size For the assignment document copy and paste the output graph from the Excel Analysis ToolPak or SAS Enterprise Guide into...

The data set has mean 15 and standard deviation 2. Approximately what percentage of the observations lie between 13 and 17? The quantitative data set under consideration has roughly a bell-shaped...

The data set has mean 30 and standard deviation 4. Approximately what percentage of the observations lie between 22 and 38? The quantitative data set under consideration has roughly a bell-shaped...

Listed below are times (minutes) spent on hygiene and grooming in the morning (by randomly selected subjects) (based on data from a Svenska Cellulosa Aktiebolaget survey). Construct a table...

The pH in a reactor varies sinusoidally over the course of a day. Use least-squares regression to fit Eq. (19.11) to the following data. Use your fit to determine the mean, amplitude, and time of...

For the experimental set-up of Fig P7.20, suppose the stream velocity is unknown and the pitot stagnation tube is traversed across the boundary layer of air at 1 atm and 20C. The manometer fluid is...

An S-590 alloy component (Figure) must have a creep rupture lifetime of at least 100 days at 500(C (773 K). Compute the maximum allowable stress level. 10 T(20 + log 1,XR-h) 25 30 35 40 45 50 1000...

Consider Triple Trice's call option with a $25 strike price. The following table contains historical values for this option at different stock prices: Create a table which shows (a) Stock price, (b)...

For an 18-8 Mo stainless steel (Figure), predict the time to rupture for a component that is subjected to a stress of 80MPa (11,600psi) at 700?C (973 K). 10 T(20 + log t,(R-h) 25 30 35 40 45 50 100...

Consider an 18-8 Mo stainless steel component (Figure) that is exposed to a temperature of 500(C (773 K). What is the maximum allowable stress level for a rupture lifetime of 5 years? 20 years? 10...

Assume that bond ABC and XYZ have the same maturity and the coupon rate of one bond is 5% and the second 13%. The yield curve for this issuer is flat at 8%. Based on this information, which bond is...

1.1. Focus for Professional Development ( High-leverage Topic. What topic can be addressed effectively, implemented quickly, and would yield the most impact on equitable student learning?) Citations...

Revenue for an electronic writing tablet is modeled by R(x)=0.10x2+3x , where x is the number of units sold. When 500 units are sold, revenue is $26,500. When 800 units are sold, revenue is $66,400....

A newly discovered element, "Examinium", has a half life of T1/2 = 15.0 hours. of a) If a student has a total of 3.60 x 10 atoms of Examinium, how many will remain after 111 hours? Remaining Atoms =...

2.36 Consider the following code: LDURB X10, [X11, #0] STUR X10, [X11, #8] Assume that the register X11 contains the address 0x10000000 and the data at address is 0x1122334455667788. 2.36.1 [5] What...

The GoT cups are a fast seller and you need to ensure that you have enough rolls of paper to fulfill demand. The first stage in the process is to determine the total cost of the current inventory...

Easton Co deposits all cash receipts on the day they are received and makes al cash payments by chock At the close of business on June 30, ils Cash account shows a debil balance of $70 209. Easton's...

A firm offers two products for sale. The marginal cost of one product is new zero once the first unit has been produced. The marginal cost of the other product rises as output rises. What would be...

How are qualified dividends taxed in 2012? Please give the two rates of tax which apply to qualified dividends, and specify when each of these rates applies._________________________...

Rebecca and Walter Bunge have been married for 5 years. They live at 883 Scrub Brush Street, Apt. 52B, Las Vegas, NV 89125. Rebecca is a homemaker and Walt is a high school teacher. Rebecca's Social...

David and Darlene Jasper have one child, Sam, who is 6 years old. The Jaspers reside at 4639 Honeysuckle Lane, Los Angeles, CA 90248. David's Social Security number is 577-11-3311, Darlene's is...

2.2 Explain major conceptual issues associated with designing cross-cultural studies, especially unpackaging studies.

1. Preclude comparison. The most conservative thing researchers can do is not make the comparison in the first place, concluding that it would be meaningless.

1. When someone makes claims concerning the nature of human behavior and mental processes, how do you know to believe those claims? Adopting a scientific point of view requires a good deal of healthy...