STAT-270-MF (Quantitative Methods)_Case Study
.docx
keyboard_arrow_up
School
Southern Alberta Institute of Technology *
*We aren’t endorsed by this school
Course
270
Subject
Statistics
Date
Apr 3, 2024
Type
docx
Pages
2
Uploaded by ProfWasp3652
STAT-270-MF (Quantitative Methods)
Case Study Part 1
Instructions
STAT 270 Case Study
This is a group project that requires only 1 submission per group in D2L. Part 1 – Data Collection
1.
Find a set of data from a source of your choice. The data set should have greater than 250
data points and at least 5 different variables.
2.
Download and organize the data in an Excel spreadsheet. Include the source web page for
the data and the date it was collected.
3.
Submit the Excel file in D2L under Assignments for Approval.
4.
Once your data set has been approved you can move on to Part 2.
Due Date: ASAP (Part 2 Due Oct 2, 2023)
Remember, material that is submitted should be presented in a well-organized and professional manner. Marks may be deducted for poor organization, formatting, spelling and grammar.
Case Study Part 2
Instructions
STAT 270 Case Study
This is a group project that requires only 1 submission per group in D2L. Part 2 – Data Description
1.
Create a copy of your data in a new tab in your Excel workbook.
2.
Provide an example of the following items in your data. You can do this by highlighting and adding a comment or using a textbox and arrow to point to the item.
a.
Element
b.
Variable
c.
Constant
d.
Observation
3.
For each variable in your data set and answer the following:
a.
Is the data qualitative or quantitative?
b.
If it is quantitative, is it discrete or continuous?
c.
What level of measurement is the data?
4.
Submit the Excel file in D2L under Assignments.
Due Date: Oct 2, 2023
Remember, material that is submitted should be presented in a well-organized and professional
manner. Marks may be deducted for poor organization, formatting, spelling and grammar.
Case Study Part 3
Instructions
STAT 270 Case Study
This is a group project that requires only 1 submission per group in D2L. Part 3 – Sampling and Visualization
1.
Select one quantitative variable in your data and copy it to a new tab. - Taiyo
2.
Take a sample of 50 data points. Complete the sampling in Excel showing the formulas or functions you used to do the sampling. - Taiyo
3.
Provide justification on what sampling method you used and why
. - Lhen 4.
Looking at the data sample, what type of charts would apply to the data you have collected. - Amir
5.
Organize the data into a frequency distribution table and discuss the following:
a.
How many classes would you recommend? Use the guidelines discussed in class to support your recommendation
.
- Amir
b.
What class interval would you suggest? Use the guidelines discussed in class and provide calculations to support your recommendation. - Elsa
c.
What lower limit would you recommend for the first class and why? - Elsa
6.
Use the frequency distribution to plot an appropriately formatted chart for the data. - Mhaj
To be upload by - Lhen
Checking of Grammars/Final Formatting - Mhaj
Due Date: Oct 9, 2023
Remember, material that is submitted should be presented in a well-organized and professional manner. Marks may be deducted for poor organization, formatting, spelling and grammar.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
tion 2 of 15
Last summer, the Smith family drove through seven different states and visited various popular landmarks. The prices of gasoline
in dollars per gallon varied from state to state and are listed below.
$2.34, $2.75, $2.48, $3.58, $2.87, $2.53, $3.31
Click to download the data in your preferred format.
CrunchIt! CSV Excel JMP Mac Text Minitab PC Text R SPSS TI Calc
Calculate the range of the price of gas. Give your solution to the nearest cent.
range:
dollars per gallon
DELL
&
4.
7
8.
arrow_forward
Explain when can we use data grouping?
arrow_forward
Write the aims of data classification
arrow_forward
Just need help with part 3, thank you!
arrow_forward
Continue monitoring the process. A second ten days of data have been collected, see table labeled “2nd 10 Days of Monitoring Reservation Processing Time” in the Data File.
Develop Xbar and R charts for the 2nd 10 days of monitoring. Plot the data for the 2nd 10 days on the Xbar and R charts.
Is the reservation process for the 2nd 10 days of monitoring in control? If the control chart indicates an out-of-control process, note which days, the pattern, and whether it is the Xbar or R chart.
Based on the X-bar and R Charts that you developed for the 2nd 10 days of data, is the process in control?
Group of answer choices
No. The X-bar and R Charts are both out of control.
No. The X-bar Chart is in control, but the R Chart is out of control.
No. The R Chart is in control, but the X-bar Chart is out of control.
Yes. The X-bar and R Charts are both in control.
arrow_forward
Classification of Data
Identify the individuals and give the variables under the following:
1.
You want to study about the people who climbed Mt. Everest.
2.
The Department of Agriculture wishes to conduct a study about the pineapples in Tagaytay.
arrow_forward
Briefly explain the procedure you may adopt to summarize data set obtained from field study.
arrow_forward
Data is shared with us every day and we encounter it wherever we go. There are different types of data from a variety of data sources.
Identify 4 different types of data.
arrow_forward
Now monitor the process. An additional ten days of data have been collected, see table labeled “1st 10 Days of Monitoring Reservation Processing Time” in the Data File.
Develop Xbar and R charts for the 1st 10 days of monitoring. Plot the data for the 1st 10 days on the Xbar and R charts.
Is the process in control? If the control chart indicates an out-of-control process, note which days, the pattern, and whether it is the Xbar or R chart.
Based on the X-bar and R Charts that you developed for the 1st 10 days of data, is the process in control?
Group of answer choices
No. The X-bar and R Charts are both out of control.
No. The X-bar Chart is in control, but the R Chart is out of control.
No. The R Chart is in control, but the X-bar Chart is out of control.
Yes. The X-bar and R Charts are both in control.
arrow_forward
Exercise 2-44 (Algo) (LO2-2)
According to the Pizza Today Magazine, an estimate of pizza sales in the United States for the top 100 pizza companies was $44.8 million in 2019. Below are the top 5 companies with the number of franchise units and total gross sales in $ millions.
Click here for the Excel Data File To complete this exercise, please access the data set in Connect with the top 100 pizza companies.
a. Using the data set, compute the sales per unit. (Enter the answers in $ millions. Round your answers to 3 decimal places.)
Name
Units
Sales ($ Millions)
Domino’s
14,563
12,252
Pizza Hut
16,417
12,034
Little Caesars Pizza
5,391
4,000
Papa John’s International
5,096
3,695
California Pizza Kitchen
262
840
b. Construct a frequency distribution of companies based on total sales. (Enter the answers in $ millions.)
Sales ($ millions)
Frequency
0 up to 1,950
96
1,950 up to 3,900
1
3,900 up to 5,850
1
5,850 up to 7,800
0
7,800 up to 9,750
0
9,750 up…
arrow_forward
Give a single example in which you can explain both
1. Qualitative and quantitative data
2. Continuous and discrete data
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Elementary Geometry for College Students
Geometry
ISBN:9781285195698
Author:Daniel C. Alexander, Geralyn M. Koeberlein
Publisher:Cengage Learning
Related Questions
- tion 2 of 15 Last summer, the Smith family drove through seven different states and visited various popular landmarks. The prices of gasoline in dollars per gallon varied from state to state and are listed below. $2.34, $2.75, $2.48, $3.58, $2.87, $2.53, $3.31 Click to download the data in your preferred format. CrunchIt! CSV Excel JMP Mac Text Minitab PC Text R SPSS TI Calc Calculate the range of the price of gas. Give your solution to the nearest cent. range: dollars per gallon DELL & 4. 7 8.arrow_forwardExplain when can we use data grouping?arrow_forwardWrite the aims of data classificationarrow_forward
- Just need help with part 3, thank you!arrow_forwardContinue monitoring the process. A second ten days of data have been collected, see table labeled “2nd 10 Days of Monitoring Reservation Processing Time” in the Data File. Develop Xbar and R charts for the 2nd 10 days of monitoring. Plot the data for the 2nd 10 days on the Xbar and R charts. Is the reservation process for the 2nd 10 days of monitoring in control? If the control chart indicates an out-of-control process, note which days, the pattern, and whether it is the Xbar or R chart. Based on the X-bar and R Charts that you developed for the 2nd 10 days of data, is the process in control? Group of answer choices No. The X-bar and R Charts are both out of control. No. The X-bar Chart is in control, but the R Chart is out of control. No. The R Chart is in control, but the X-bar Chart is out of control. Yes. The X-bar and R Charts are both in control.arrow_forwardClassification of Data Identify the individuals and give the variables under the following: 1. You want to study about the people who climbed Mt. Everest. 2. The Department of Agriculture wishes to conduct a study about the pineapples in Tagaytay.arrow_forward
- Briefly explain the procedure you may adopt to summarize data set obtained from field study.arrow_forwardData is shared with us every day and we encounter it wherever we go. There are different types of data from a variety of data sources. Identify 4 different types of data.arrow_forwardNow monitor the process. An additional ten days of data have been collected, see table labeled “1st 10 Days of Monitoring Reservation Processing Time” in the Data File. Develop Xbar and R charts for the 1st 10 days of monitoring. Plot the data for the 1st 10 days on the Xbar and R charts. Is the process in control? If the control chart indicates an out-of-control process, note which days, the pattern, and whether it is the Xbar or R chart. Based on the X-bar and R Charts that you developed for the 1st 10 days of data, is the process in control? Group of answer choices No. The X-bar and R Charts are both out of control. No. The X-bar Chart is in control, but the R Chart is out of control. No. The R Chart is in control, but the X-bar Chart is out of control. Yes. The X-bar and R Charts are both in control.arrow_forward
- Exercise 2-44 (Algo) (LO2-2) According to the Pizza Today Magazine, an estimate of pizza sales in the United States for the top 100 pizza companies was $44.8 million in 2019. Below are the top 5 companies with the number of franchise units and total gross sales in $ millions. Click here for the Excel Data File To complete this exercise, please access the data set in Connect with the top 100 pizza companies. a. Using the data set, compute the sales per unit. (Enter the answers in $ millions. Round your answers to 3 decimal places.) Name Units Sales ($ Millions) Domino’s 14,563 12,252 Pizza Hut 16,417 12,034 Little Caesars Pizza 5,391 4,000 Papa John’s International 5,096 3,695 California Pizza Kitchen 262 840 b. Construct a frequency distribution of companies based on total sales. (Enter the answers in $ millions.) Sales ($ millions) Frequency 0 up to 1,950 96 1,950 up to 3,900 1 3,900 up to 5,850 1 5,850 up to 7,800 0 7,800 up to 9,750 0 9,750 up…arrow_forwardGive a single example in which you can explain both 1. Qualitative and quantitative data 2. Continuous and discrete dataarrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillBig Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
- Elementary Geometry for College StudentsGeometryISBN:9781285195698Author:Daniel C. Alexander, Geralyn M. KoeberleinPublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Elementary Geometry for College Students
Geometry
ISBN:9781285195698
Author:Daniel C. Alexander, Geralyn M. Koeberlein
Publisher:Cengage Learning