Question: Use the frequency table below to find the mean and standard deviation using excel. Number of Adults in Household. Frequency 1 1649 2 3723 3

Use the frequency table below to find the mean and standard deviation using excel.

Number of Adults in Household. Frequency

1 1649
2 3723
3 2191
4 1743
5 1209
6 809
7 519
8 389
9 202
10 134
11 57
12 49
13 22
14 19
15 16
16 7
17 4
18 8
19 0
20 5
21 2
22 3
23 1
24 0
25 1
26 0
27 0
28 1
29 0
30 2
31 1
32 0
33 1
34 0
35 0
36 0
37 0
38 0
39 0
40 0
41 0
42 0
43 0
44 0
45 0
46 0
47 0
48 0
49 0
50 0
51 0
52 0
53 0
54 1

Step by Step Solution

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 Mathematics Questions!

Q:

After retiring as a physician, Bob Guthrie became an avid downhill skier on the steep slopes of the Utah Rocky Mountains. As an amateur inventor, Bob was always looking for something new. With the...

Q:

CoursHeroTranscribedText: Question 1 The daily volume of a brokerage company follows a normal distribution. The director wants to estimate the daily volume negotiated. a) What size should have a...

Q:

Host 1 R1 Eno GO GO/1 GO GO losv 2-0 desktop-0 Subnet A Link 3 *00/1 lov-2 R3 R2 Link 1 GOO Josk-1 Link 2 GOO Link 4 Subnet B 22 GOO Etho Host 2 los-3 R4 losv12-1 desktop-1

Q:

Ideal Gases, Compressibility Factors and Polytropic Processes 1) Determine the specific volume of water vapor at 10 MPa and 375 C. 18.015 kg kamol, T, = 647.1 K and P = 22.06 MPa Using tables b....

Q:

Use the frequency table below to find the 5% trimmed mean, the median, the variance, interquartile range, skewness, and Kurtosis using excel. Number of Adults in Household. Frequency 1 1649 2 3723 3...

Q:

All additional information is below, including data sets & table templates Document (4) - Saved A X, More Formatting A - Part 1: Random Data, Statistics, and the Empirical Rule Methods: Use Excel (or...

Q:

Purpose: The purpose of this assignment is to organize a random sample of data values and create statistics, tables, and a graph based on the data.Then the sample data will be compared to the...

Q:

I submitted this proyect this morning but so far nobody has helped me to solve it. Data set 2.87 7.05 2.92 7.23 3.56 7.38 4.46 7.48 4.51 7.83 4.71 7.99 4.98 8.12 5.23 8.45 5.45 8.68 5.51 8.81 5.59...

Q:

\begin{tabular}{|r|r|r|r|r|r|} \hline \multicolumn{1}{|l|}{DataSetR} & & Mu=31.2 & & sd=4.5 & n=46 \\ \hline & & & & & \\ \hline 31.0 & 34.9 & 31.4 & 27.4 & 37.6 & 38.2 \\ \hline 32.8 & 32.0 & 26.4 &...

Q:

1. 44% of adults say cashews are their favorite kind of nut. You randomly select 12 adults and ask each to name his or her favorite nut. Find the probability that the number who say cashews are their...

Q:

Use the data below to create frequency distribution table using 6 classes. Use the frequency distribution table to find the mean of the distribution as well as relative frequency, cumulative...

Q:

A chef needs to prepare 90 portions of cooked broccoli. Each portion will be 3 oz. after cooking. This vegetable loses 39% of its weight when cooked. How many pounds of raw broccoli must be purchased?

Q:

The following information pertains to telephone calls to a call centre on a typical workday. Assume Poisson arrivals and Exponential service durations. a. Determine the average time callers wait to...

Q:

Find the limit of the sequence with the given n th term. a n = 3 n 5 3 n

Q:

A rocket starts from rest in free space by emitting mass, at what fraction of the initial mass is the momentum a maximum?

Q:

Consider the game of tennis when deuce is reached. If a player wins the next point, he has advantage. On the following point, he either wins the game or the game returns to deuce. Assume that for any...

Q:

Find a general solution of the ODE y'' + w2y = r(t) with r(t) as given. (Show the details of yourwork.) if -7/2

Q:

Heath Foods bonds have 7 years remaining to maturity. The bonds have a face value of $1,000 and a yield to maturity of 8 percent. They pay interest annually and have a 9 percent coupon rate. What is...

Q:

A proton with mass m moves in one dimension. The potential-energy function is U(x) = alx2- B/x, where a and p are positive constants. The proton is released from rest at Xo = alp. (a) Show that U(x)...

Q:

Determine if the overhead allocated to the product relates to a single plantwide overhead rate method, multiple production department factory overhead rate method, or activity-based costing...

Q:

Let {N(t), t 0} denote a Poisson process with rate and define Y (t) to be the time from t until the next Poisson event. (a) Argue that {Y (t), t 0} is a stationary process. (b) Compute Cov[Y (t), Y...

Q:

Let X(t) = N(t + 1) N(t) where {N(t), t 0} is a Poisson process with rate . Compute Cov[X(t), X(t + s)]

Q:

Let {Z(t), t 0} denote a Brownian bridge process. Show that if Y (t) = (t + 1)Z(t/(t + 1)) then {Y (t), t 0} is a standard Brownian motion process.