File attached

Quantitative Management Course Project.

The Total project (Phase I, II, & III) counts for 30% of the final course grade; therefore, extreme attention to detail is required. A Gold Standard Project for all phases combined (I, II, III) is generally between 30-40 pages including Tables, Figures, References, etc.

Course Project Phase III counts 15% of total course grade.

Perform and thoroughly explain the following analysis using the provided project files: (All items in Italic are discussion items, and calculations not required. Graphs, charts, or figures explaining concepts are encouraged.)

Phase I

1. Ch 2 -Graphical Data Analysis

   1. Stem-and-Leaf Plot

   2. Clustered Bar Chart (Use noted Excel data) Create and explain relationships between variables.

   3. Scatter Plot (Use noted Excel data) Create and explain relationships between variables.

   4. Show frequency and relative frequency with a Pivot Table (Use noted Excel data).

   5. Distributions (Create Histograms, calculate/display Mean & Median for explanations)

      1. Normal (use Exam1Sp & Exam2Sp data.)

         1. create a Histogram for each Exam’s data.

         2. create a combined Histogram showing both Exam’s data in the same Histogram.

      2. Left-Skewed (Use noted Excel data)

      3. Right Skewed (Use noted Excel data)

      4. Bimodal (Use noted Excel data)

2. Ch 3 - Descriptive Statistics

1. Measures of Central Tendency

   1. Mean, Median, Mode

2. Measures of Variability

   1. Range, Variance & Standard deviation

3. Measures of Extrema

   1. Min, Max

   2. Outliers

d. Ch 3 - Box Plot

1. 1. 1. Interquartile Range (use Item 1 data).

2. Ch 3 - In your own words discuss Empirical Rule and the value to business, please give an example. (Graphic to illustrate and explain is highly encouraged.)

Phase II

1. Ch 4 – Probability (Use noted data in Excel)

2. Ch 7 - In your own words discuss Central Limit Theorem.

3. Ch 7 – Proportions (Use noted data in Excel)

4. Ch 8 - Confidence Interval for the difference between Means (Use noted data in Excel)

5. Ch 9 – In your own words discuss Hypothesis Testing, including types, conclusions, error risks, roll of p-value, etc.

6. Ch 9 – Hypothesis Testing

   1. Lower Tailed t-Test (Use noted data in Excel)

   2. Upper Tailed t-Test (Use noted data in Excel)

   3. Two tailed Test. (Use noted data in Excel)

7. Ch 10 – Test for significant difference between means. (Use noted data in Excel)

8. Ch 11 – ANOVA (Use noted data in Excel)

Phase III

1. Ch 12 – Chi-Sq Test

   1. Comparing Two or More Population Proportions

   2. Testing the Independence of Two Variables

2. Ch 13 - Testing the Variance of a Single Population

3. Ch 14 – In your own words discuss Correlation.

4. Ch 14 – Linear Regression Analysis

5. Ch 15 – In your own words discuss Multicollinearity.

6. Ch N/A – In your own words discuss Parsimony. (Not in textbook, must cite reputable source, no websites accepted.)

7. Ch 15 – Multiple Linear Regression Analysis – Improving Predictive ability.

8. Ch 16 – Forecasting

1. 1. (SMA) Moving Average

   2. (WMA) Weighted Moving Average

   3. Linear Trend using Regression

   4. Seasonality

1. Summarize the value to the organization of making informed decisions using quantitative analysis.