Question

2. The following data show the number of cars that arrived at a Tim-Hortons drive-through between 10:00 AM and 11:00 AM each Monday for the past 50 weeks:

1 6 5 4 2 7 5 3 4 5 3 6 6 9 6 8 4 3 3 1 2 3 3 5 7 3 4 4 2 1 8 3 3 3 5 2 8 2 5 3 6 1 1 5 8 3 2 2 5 4

(a) Construct a frequency distribution table and a relative frequency distribution of the data by hand with 9 classes and a class width of 1.

(b) Use Excel to construct a histogram based on the frequency distribution table (you can copy the data directly into excel) following the procedure outlined below. • On your worksheet, add a new column anywhere with the data and a second column with the upper class limits in order. (Note: EXCEL needs the upper 2 class limits, not lower class limits). • Install the Data Analysis ToolPak: Click the File tab and then click Options. Select Add-Ins on the left, click Analysis ToolPak in the list on the right, and then in the Manage box, select Excel Add-ins. Click Go. Select Analysis ToolPak and click Ok. • Click the Data tab in the top menu and click Data Analysis • Select Histogram and click Ok. • Click the Input Range box and select the column of data • Click the Bin Range box and select the upper class limit column data • Select New Worksheet Ply and Chart Output; click Ok

(c) What percentage of weeks had exactly three cars arrive between 10:00 AM and 11:00 AM?

(d) What percentage of weeks had three or more cars arrive between 10:00 AM and 11:00 AM?

Answer #1

( I. freq Relative freq 0-1 0.1 7. 014 1-2 2-3 12. 0.24 0.12 3- 4 4-5 0.16. 0.04 0.08 8-9. 0.02. 50

A Bin G H Frequency Histogram O-ANOC av Frequency 11 More Frequency OSMOS 1 2 3 4 5 6 7 8 9 More Bin

Problem #1 Confidence Interval for Means using the t and
z Distribution. Psychologists studied
the percent tip at a restaurant when a message indicating that the
next day’s weather would be nice was written on the bill. Here are
tips from a random sample of patrons who received such a bill,
measured in percent of the total bill:
20.8 18.7
19.9 20.6
21.9 23.4
22.8 24.9
22.2 20.3
24.9 22.3
27.0 20.4
22.2 24.0
21.1 22.1
22.0 22.7
Open an...

PROBLEM 1: Analyze the following data using
LINEAR TREND ANALYSIS. How many cars will be sold
in time period 13? USE EXCEL
TIME PERIOD
NUMBER OF CARS SOLD
1
70
2
80
3
66
4
74
5
64
6
76
7
72
8
83
9
82
10
76
11
84
12
80

Suppose that the following frequency table contains data on the
number of absences in a school year due to illness or injury for
100 randomly selected high school students. Use the table to
determine the median number of absences for these 100 students.
Provide your answer with precision to one decimal place.
Number of absences 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11
Frequency 25, 10, 10, 5, 9, 12, 9, 9, 4, 2, 3, 2...

Pulse
Frequancy
Minimum
Maximum
Class width
PULSE
60
74
86
54
90
80
66
68
68
56
80
62
74
60
52
60
66
64
64
46
68
58
68
70
56
66
78
68
62
70
72
74
64
50
70
58
60
88
84
76
46
68
58
68
70
56
66
78
68
62
constructing a frequency table
1 decide on the number of classes(should be between 5 and 20
2 calculate round up (highest value)-(lowest value)/number...

Cortland Software, Inc. surveyed a sample of its programmers and
recorded the following data on their: age, gender, years of
programming experience, whether or not they have a master’s degree,
and annual salary.
Programmer
Age
Gender
Years of
Experience
Master’s
Degree
Salary
1
32
Male
8
No
$59,450
2
27
Male
2
Yes
62,750
3
31
Female
6
Yes
65,820
4
37
Males
5
No
54,620
5
29
Female
5
Yes
61,900
6
25
Female
4...

Excel Lab 2: Regression and Goal Seek
In this lab, you will use Excel to determine the equation of the
model which best fits a set of ordered pairs
obtained from data sets. You will enter data, graph the data, find
the equation for the regression model,
and then use that equation to make predictions for the dependent
variable. You will use the goal seek to make
predictions for the independent variable. Then you will consider
how accurate your predictions...

For the following data
10,
15, 30, 30, 31, 31, 32, 32, 33, 33, 34, 36, 38, 39, 40, 40, 43, 44,
44, 45, 46, 46, 46, 47, 47, 48, 48,
60,
70.
Make a frequency diagram with 6 classes
Class
Interval (CI) Frequency (f)
1
2
3
4
5
6
Give the five-number summary
1. minimum…………………………………….
2. Q1……………………………………………….
3. Q2………………………………………………
4. Q3……………………………………………...
5. Maximum…………………………………...
Are there any outliers, if so, what are
they?
No.
Yes. The lower bound……………………………....

The number of defects in 12 different production runs
were 2, 5, 10, 0, 5, 3, 4, 3, 2, 2, 0 and 0. This data can be
summarized in a frequency distribution as follows a. The values
that occur in the set in increasing order are 0, 2, 3, 4, 5 and 10.
b. The frequency of 0 is 3 since it occurs 3 times in the set. The
frequency of 2 is 3 since it occurs 3 times in...

For the following data
10,
15, 30, 30, 31, 31, 32, 32, 33, 33, 34, 36, 38, 39, 40, 40, 43, 44,
44, 45, 46, 46, 46, 47, 47, 48, 48,
60,
70.
Make a frequency diagram with 6 classes
Class
Interval (CI) Frequency (f)
1
2
3
4
5
6
Give the five-number summary
1. minimum…………………………………….
2. Q1……………………………………………….
3. Q2………………………………………………
4. Q3……………………………………………...
5. Maximum…………………………………...
Are there any outliers, if so, what are
they?
No.
Yes. The lower bound……………………………. The...

Using samples of 200 credit card statements, an Auditor found
the following:
---Sample Number: 1 2
3 4
5 6 7 8
9 10 11
12 13 14 15
Number of Errors: 17 12
11 12 10 10
17 15
12 13
15 10
7 8 10
Determine lower and upper control limits for the fraction of
errors using three-sigma limits.
Question 8 options:
0 , .126
.017 , .101
.026 , .093
.009 , .109
None of the Above
The Quality Control...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 11 minutes ago

asked 16 minutes ago

asked 23 minutes ago

asked 39 minutes ago

asked 42 minutes ago

asked 49 minutes ago

asked 54 minutes ago

asked 59 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago