QNT 561 – Week 1 Syllabus
Week 1 Assignments
Descriptive Statistics and Probability Distributions
- Compute descriptive statistics for given data sets.
Apply probability concepts related to discrete and continuous probability distributions.
Install the Microsoft® Excel Add-in MegaStat® to help in your statistical calculations for this course. The MegaStat® Web link is located on your rEsource page. Click the link and follow the directions for installation.
Assignments
I1 Individual Assignment – Obtain sample data (n<=50) from your work, the text or the internet. Explain what the data measures and run Megastats Descriptive Statistics. Do an in-depth descriptive statistics write-up of this data. Explain all items checked and offer insights as to possible meanings.
G1 Learning Team – Develop several research problems & questions for the final research paper and presentation. The instructor must approve the proposal.
Form Learning Teams. These teams will work together throughout the course.
Learning Team - Review the objectives from Week One, and discuss additional insights and questions that may have arisen.
Learning Team - Learning Teams prepare the Learning Team Log before the next class meeting.
QRB 501 – G6 Data
| MEGASTAT CORRELATION MATRIX | |||
| G6 | |||
| Do the variables significantly effect sales of heart valves? Which ones? | |||
| Alpha = .01 | |||
| Ho: No Relationship H1: Relationship | |||
| Size= Size of the valvue, 1= small, 2=medium, 3= large, 4=X-large | |||
| Age= Age of patient | |||
| Distance= Distance of patients residence to a fast food restaurant in kilometers. | |||
| Sales= Sales in 1000 dollars | |||
| SIZE | AGE | DISTANCE | SALES |
| 1 | 55 | 14 | 8 |
| 3 | 84 | 9 | 12 |
| 2 | 75 | 3 | 15 |
| 4 | 75 | 9 | 6 |
| 3 | 66 | 6 | 9 |
| 2 | 59 | 4 | 10 |
| 1 | 48 | 22 | 7 |
| 4 | 72 | 3 | 9 |
| 3 | 61 | 7 | 8 |
| 2 | 86 | 8 | 7 |
| 1 | 92 | 2 | 15 |
| 3 | 80 | 1 | 12 |
| 2 | 68 | 3 | 10 |
| 4 | 59 | 6 | 9 |
| 2 | 45 | 9 | 7 |
| 1 | 79 | 1 | 14 |
| 4 | 65 | 4 | 11 |
| 3 | 48 | 2 | 8 |
| 4 | 72 | 1 | 13 |
| 1 | 62 | 5 | 9 |
QRB 501 – Week 6 – Team Work Distribution
Editor – Karen
Construct the research problem, question and purpose. Construct the null and alternative hypothesis. – Shannon
Do Descriptive statistics and graph the data for each group. Do a write-up of the descriptive stats. Use an alpha level of significance of .05. – Peggi
Run a Megastat Correlation/Regression, Regression Matrix test. Explain the multiple relationships. – Rupa
Conclude and make recommendations. – Daniel
QRB 501 – Week 6 Syllabus
WEEK 6 – TOPIC 1: BUSINESS APPLICATIONS II
Objectives
- Apply basic probability concepts.
- Explain the importance of the central limit theorem in sampling.
- Convert data to indexes.
I6 Simple Regression Case Analysis: Riverside Chamber of Commerce
ABC Corporation of California publishes a variety of statistics, including the number of individuals who got a new job during the past 12 months and the mean length of time the individuals have been on the job. A local Chamber of Commerce for the City of Riverside has commissioned a study on the status of employment in the Riverside area. A sample of 16 employed residents of Riverside included data on the age and the number of weeks on a job. A portion of the data collected is shown as follows:
|
55
|
21
|
|
30
|
18
|
|
23
|
11
|
|
52
|
36
|
|
41
|
19
|
|
25
|
12
|
|
42
|
7
|
|
45
|
25
|
|
25
|
6
|
|
40
|
21
|
|
25
|
13
|
|
25
|
11
|
|
59
|
34
|
|
49
|
27
|
|
33
|
18
|
|
35
|
20
|
Address the following:
- Construct the research problem, question, purpose, null and alternative hypothesis. Do Descriptive statistics and graph the data for each group. Do a write-up of the descriptive stats. Conduct a Regression Analysis. Use a .01 level of significance.
- Is there a correlation/association/relationship between the age of a newly employed individual and the number of weeks of employment? Analyze the r value and the r ² value. What is your conclusion? Explain.
G6 Correlation Matrix Multiple Regression Analysis.
-
- Group Correlation/Regression, Regression Matrix. Data to be determined in class.
- Construct the research problem, question and purpose. Construct the null and alternative hypothesis. Do Descriptive statistics and graph the data for each group. Do a write-up of the descriptive stats. Use an alpha level of significance of .05.
- Run a Megastat Correlation/Regression, Regression Matrix test. Explain the multiple relationships. Conclude and make recommendations.
QRB 501 – Week 5 Syllabus
I5 Caffeine and Finger Tapping One Way ANOVA
An investigation was conducted into the effect of the stimulant caffeine on the performance of a simple task. Thirty two male students were trained on finger tapping and divided into four random groups of eight. The groups were given different doses of caffeine and 2 hours after treatment each student was required to carry out finger tapping. The number of taps per minute was recorded. Does finger tapping change with the intake of caffeine? Alpha= .05.
- Construct the research problem, question, purpose, null and alternative hypothesis. Do Descriptive statistics and graph the data. Do a write-up of the descriptive stats. Conduct an Analysis of Variance One-Factor Anova test. If the result is “reject” analyze the p-values of the Tukey post hoc analysis. Explain the differences: (0-100, 0-200, 0-300, 100-200, 100-300, 200-300). Conclude and make recommendations. Don’t forget references.
|
0 ml |
100ml |
200ml |
300ml |
|
|
|
|
|
|
242 |
248 |
246 |
248 |
|
245 |
246 |
248 |
250 |
|
244 |
245 |
250 |
251 |
|
248 |
247 |
252 |
251 |
|
247 |
248 |
248 |
248 |
|
248 |
250 |
250 |
251 |
|
242 |
247 |
252 |
252 |
|
244 |
246 |
248 |
249 |
G5 WENTWORTH MEDICAL CENTER (ANOVA)
| MEDICAL ONE | MEDICAL TWO | ||||
|
FLORIDA |
NEW |
NORTH |
FLORIDA |
NEW |
NORTH |
|
|
YORK |
CAROLINA |
|
YORK |
CAROLINA |
|
3 |
8 |
10 |
13 |
14 |
10 |
|
7 |
11 |
7 |
12 |
9 |
12 |
|
7 |
9 |
3 |
17 |
15 |
15 |
|
3 |
7 |
5 |
17 |
12 |
18 |
|
8 |
8 |
11 |
20 |
16 |
12 |
|
8 |
7 |
8 |
21 |
24 |
14 |
|
8 |
8 |
4 |
16 |
18 |
17 |
|
5 |
4 |
3 |
14 |
14 |
8 |
|
5 |
13 |
7 |
13 |
15 |
14 |
|
2 |
10 |
8 |
17 |
17 |
16 |
|
6 |
6 |
8 |
12 |
20 |
18 |
|
2 |
8 |
7 |
9 |
11 |
17 |
|
6 |
12 |
3 |
12 |
23 |
19 |
|
6 |
8 |
9 |
15 |
19 |
15 |
|
9 |
6 |
8 |
16 |
17 |
13 |
|
7 |
8 |
12 |
15 |
14 |
14 |
|
5 |
5 |
6 |
13 |
9 |
11 |
|
4 |
7 |
3 |
10 |
14 |
12 |
|
7 |
7 |
8 |
11 |
13 |
13 |
|
3 |
8 |
11 |
17 |
11 |
11 |
As part of a long-term study of individuals 65 years of age or older, sociologists and physicians at the Wentworth Medical Center in upstate New York conducted a study to investigate the relationship between geographic location and depression.
A random sample of 60 individuals, all in good health, was selected. (Listed as Medical One): 20 from Florida, 20 from New York, 20 from North Carolina.
A secondary part of the study-tested individuals 65 years or older that had chronic health conditions such as arthritis, hypertension or heart ailment. (Listed as Medical Two). Each of the individuals sampled was given a standardized test to measure depression. High-test scores indicate higher levels of depression. Healthy or sick does it matter what state you live in? Alpha= .05.
- Construct the research problem, question, purpose, null and alternative hypothesis. Do Descriptive statistics and graph the data for each group. Do a write-up of the descriptive stats. Conduct an Analysis of Variance One-Factor Anova test for each group. If the result is “reject” analyze the p-values of the Tukey post hoc analysis. Explain the differences. Conclude and make recommendations. Don’t forget references.
QRB 501 – Week 4 Syllabus
I4 Two Sample T-Test Cell Phone Plastic Test
Fifteen cell phones were tested for crushing resistance. The measured variables are in pounds per square inch (PSI). The resistance of the first batch were recorded: 50, 36, 34, 45, 56, 42, 53, 25, 65, 33, 40, 42, 39, 43, 42. Another batch of 15 were measured after being heated to120 degrees Fahrenheit for six hours: 43, 44, 51, 40, 29, 49,39, 59, 43, 48, 67, 44, 46, 54, 64.
- Construct the research problem, question and purpose. Construct the null and alternative hypothesis. Use an alpha level of significance of .05.
- Do Descriptive Statistics on this data and describe the data in a write-up. Run Megastat, Hypothesis Tests, Compare Two Independent Groups, T-Test (Pooled Variance), Hypothesized Difference: Zero. Explain the differences. Conclude.
G4 Group
The Sacramento Medical center added a new wing. The plan was for the new wing to increase the average number of patients per day above the 25 average before the addition. The following data lists a random sample of 15 days with the number of patients. Did the plan work?
25, 27, 25, 26, 25, 28, 28, 27, 24, 26, 25, 29, 25, 27, 24.
One Sample T-Test Sacramento Medical Center:
QRB 501 – Week 3 Syllabus
VISUAL REPRESENTATION OF QUANTITIES
Objectives
-
Construct histograms using Excel.
- Use time series data to forecast.
Individual I3 Descriptive Statistics
Come up with two sets of data that would address the research problem and question formulated in week Two I2. Run Megastats, Descriptive Statistics on this data and describe the data in a write-up. List any important observations and run a Goodness of Fit (GOF) test to determine if they are normal distributions.
Group G3 Descriptive Statistics
Come up with two sets of data that would address the research problem and question formulated in week Two G2. Run Megastats, Descriptive Statistics on this data and describe the data in a write-up. List any important observations and run a Goodness of Fit (GOF) test to determine if they are normal distributions.
QRB 501 – Week 2 Syllabus
Objectives
- Differentiate the levels of measurement.
- Solve simultaneous equations algebraically.
I2 Individual Research Problem – Research Question.
Identify a research problem. Formulate a research question to address this problem.
Prepare a paper describing the research problem in detail. How does the research question deal with the problem? What possible variables would you measure? What data would you gather?
G2 Group Research Problem – Research Question.
Identify a research problem. Formulate a research question to address this problem.
Prepare a paper describing the research problem in detail. How does the research question deal with the problem? What possible variables would you measure? What data would you gather?
QRB 501 – Week 1 Instructors Syllabus
WEEK 1 – TOPIC 1: WORKING WITH NUMBERS AND FORMULAS Objective I1. Research Report Abstract and Comment. Identify a research paper in the UOP Library that deals with an economic or business problem of interest. Copy the abstract on to a Word document. Below the abstract describe in your own words the research problem, research question and the results. How does the research question deal with the problem? What was the sample size? What variables are measured? What were the results?
QRB 501 – Week 1 Syllabus
QRB/501 QUANTITATIVE REASONING FOR BUSINESS
COURSE DESCRIPTION
This course applies quantitative reasoning skills to business problems. Students learn to analyze data using a variety of analytical tools and techniques. Other topics include formulas, visual representation of quantities, time value of money, and measures of uncertainty.
WEEK 1 – TOPIC 1: WORKING WITH NUMBERS AND FORMULAS
Objectives
Write mathematical expressions and equations for word problems.
Apply the rules for order of operations (including exponents) in solving problems.
Identify dependent and independent variables and their relationships
Materials
EBook
SUPPLEMENT: Week One Student Road Map SUPPLEMENT: Week One Mind Map SUPPLEMENT: Week One Content Outline WEB LINK: Verify or Install Excel Add-In Megastat
|
|
|
|
Additional Week One Materials
Online Tutoring Online tutoring is available through the Center for Mathematics Excellence. Please review the “CME Online Tutoring- Overview” and the “CME Online Tutoring- Getting Started” documents to become familiar with this supplemental tool.
Assessment
Complete the following order of operations questions:
McConnell & Brue text
- Ch. 7, study question 12
- Ch. 8, study questions 2 and 11
- Ch. 20, study question 2
- Ch. 22, study question 7
Marshall, McManus, & Viele text
- Ch. 3, exercise E3.6
Complete the following dependent and independent variables question from the Horngren text:
- Ch. 2, question 2B2
WEB LINK: CME Online Tutoring – Overview WEB LINK: CME Online Tutoring – Getting Started
