Question

How do i plot the frequency distribution and normal PDF of these figures to give me histogram showing a bell shaped pdf in excel

3.8 4.6 4.6 4.9 5.2 5.3 5.3 5.4 5.6 5.6 5.7 5.8 5.9 6.0 6.1 6.1 6.3 6.3 6.4 6.5 6.6 6.8 7.0 7.4 7.6

Answer #1

Steps to plot the frequency distribution:

1) Click the Data tab’s Data Analysis command button to tell Excel that you want to create a frequency distribution and a histogram.

2) When Excel displays the Data Analysis dialog box, select Histogram from the Analysis Tools list and click OK.

3) In the Histogram dialog box that appears, identify the data that you want to analyze.

4) Tell Excel where to place the frequency distribution and histogram.

5) Click OK.

SHOW ALL WORK. DO NOT USE SOFTWARE TO GENERATE ANSWERS.
Calculate the R-chart and X-bar chart limits for the data given
below.
Day
A
B
C
D
1
7.2
8.4
7.9
4.9
2
5.6
8.7
3.3
4.2
3
5.5
7.3
3.2
6.0
4
4.4
8.0
5.4
7.4
5
9.7
4.6
4.8
5.8
6
8.3
8.9
9.1
6.2
7
4.7
6.6
5.3
5.8
8
8.8
5.5
8.4
6.9
9
5.7
4.7
4.1
4.6
10
3.7
4.0
3.0
5.2
11
2.6
3.9...

An important statistical measurement in service facilities (such
as restaurants and banks) is the variability in service times. As
an experiment, two bank tellers were observed, and the service
times for each of 100 customers were recorded. Do these data allow
us to infer at the 5% significance level that the variance in
service times differs between the two tellers? Estimate with 95%
confidence the ratio of variances of the two bank tellers. Teller 1
Teller 2 7.2 10.9 5.4...

Use the data in Bank Dataset to answer this question.
Construct a 95% confidence interval for the mean increase in
deposits. Note that the population standard deviation σ is not
known in this case. Instead the sample standard deviation s should
be calculated from the sample and the t distribution should be
used.
2. What is the margin of error at the 95% confidence level?
Bank Dataset of Increase in deposits. Mean is 4. Sample size is
152 customers.
4.3...

Price
Level
Quantity of Real GDP Demanded
Quantity
of Real GDP supplied
($
trillion)
($ Trillion)
100
7.8
4.8
120
7.6
5.2
140
7.4
5.6
160
7.2
6.0
180
7.0
6.2
200
6.8
6.4
220
6.6
6.6
240
6.4
6.8
260
6.2
7.0
280
6.0
7.2
300
5.8
7.4
Use the data in the table above to answer the following
question. Assume the potential output level is $7.2 trillion.
The Federal Reserve uses monetary policy to close the output...

Med Student Sleep Average (Raw Data, Software
Required):
Here we consider a small study on the sleep habits of med students
and non-med students. The study consists of the hours of sleep per
night obtained from 30 non-med students and 25 med students. The
sample data is given in the table below. Test the claim that, on
average, the mean hours of sleep for all med students is different
from that for non-med students. Test this claim at the 0.05...

A research psychologist wishes to investigate the difference in
maze test scores for a strain of laboratory mice trained under
different laboratory conditions. The experiment is conducted using
18 randomly selected mice of this strain, with six receiving no
training at all (control group), six trained under condition 1, and
six trained under condition 2. Then each of the mice is given a
test score between 0 and 10, depending on its performance in a test
maze. A higher score...

Med Student Sleep Average (Raw Data, Software
Required):
Here we consider a small study on the sleep habits of med students
and non-med students. The study consists of the hours of sleep per
night obtained from 30non-med students and 25 med students. The
sample data is given in the table below. Test the claim that, on
average, the mean hours of sleep for all med students is different
from that for non-med students. Test this claim at the 0.01
significance...

Med Student Sleep Average (Raw Data, Software Required): Here we
consider a small study on the sleep habits of med students and
non-med students. The study consists of the hours of sleep per
night obtained from 30 non-med students and 25 med students. The
sample data is given in the table below. Test the claim that, on
average, the mean hours of sleep for all med students is different
from that for non-med students. Test this claim at the 0.05...

Year
Unemployment rate
gdp growth
cpi
inflation rate
1980
7.2
-0.2
87
1981
7.6
2.6
94
8.05
1982
9.7
-1.9
97.6
3.83
1983
9.6
4.6
101.3
3.79
1984
7.5
7.3
105.3
3.95
1985
7.2
4.2
109.3
3.80
1986
7.0
3.5
110.5
1.10
1987
6.2
3.5
115.4
4.43
1988
5.5
4.2
120.5
4.42
1989
5.3
3.7
126.1
4.65
1990
5.6
1.9
133.8
6.11
1991
6.9
-0.1
137.9
3.06
1992
7.5
3.6
141.9
2.90
1993
6.9
2.7
145.8
2.75
1994
6.1
4.0...

Data was collected from a random sample of 20 customers at both
US Bank and TCF Bank. The mean wait time at both banks was 5
minutes. The Standard Deviation for the TCF Bank wait time is
s = .476 minutes. The Standard Deviation for the US Bank
wait times is s = 82 minutes
Compare the two standard deviations and write a sentence
explaining what the difference in standard deviations means if you
are a customer waiting in line...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 5 minutes ago

asked 7 minutes ago

asked 8 minutes ago

asked 9 minutes ago

asked 14 minutes ago

asked 27 minutes ago

asked 29 minutes ago

asked 32 minutes ago

asked 35 minutes ago

asked 40 minutes ago

asked 41 minutes ago

asked 44 minutes ago