Category: Statistics

InstructionsFinal Project Assignment Instructions

Scenario Background:

A marketing company based out of New York City is doing well and is looking to expand internationally. The CEO and VP of Operations decide to enlist the help of a consulting firm that you work for, to help collect data and analyze market trends.

You work for Mercer Human Resources. The lists prices of certain items in selected cities around the world. They also report an overall cost-of-living index for each city compared to the costs of hundreds of items in New York City (NYC). For example, London at 88.33 is 11.67% less expensive than NYC.

More specifically, if you choose to explore the website further you will find a lot of fun and interesting data. You can explore the website more on your own after the course concludes.

Assignment Guidance:

In the Excel document, you will find the 2018 data for 17 cities in the data set Cost of Living. Included are the 2018 cost of living index, cost of a 3-bedroom apartment (per month), price of monthly transportation pass, price of a mid-range bottle of wine, price of a loaf of bread (1 lb.), the price of a gallon of milk and price for a 12 oz. cup of black coffee. All prices are in U.S. dollars.

You use this information to run a Multiple Linear Regression to predict Cost of living, along with calculating various descriptive statistics. This is given in the Excel output (that is, the MLR has already been calculated. Your task is to interpret the data).

Based on this information, in which city should you open a second office in? You must justify your answer. If you want to recommend 2 or 3 different cities and rank them based on the data and your findings, this is fine as well.

Deliverable Requirements:

This should be 34 to 1 page, no more than 1 single-spaced page in length, using 12-point Times New Roman font. You do not need to do any calculations, but you do need to pick a city to open a second location at and justify your answer based upon the provided results of the Multiple Linear Regression.

The format of this assignment will be an Executive Summary. Think of this assignment as the first page of a much longer report, known as an Executive Summary, that essentially summarizes your findings briefly and at a high level. This needs to be written up neatly and professionally. This would be something you would present at a board meeting in a corporate environment. If you are unsure of an Executive Summary, this resource can help with an overview.

Things to Consider:

To help you make this decision here are some things to consider:

• Based on the MLR output, what variable(s) is/are significant?
• From the significant predictors, review the mean, median, min, max, Q1 and Q3 values?
• It might be a good idea to compare these values to what the New York value is for that variable. Remember New York is the baseline as that is where headquarters are located.
• Based on the descriptive statistics, for the significant predictors, what city has the best potential?
• What city or cities fall are below the median?
• What city or cities are in the upper 3rd quartile?

Many people will view complaints in a negative sense-something went wrong, or “I failed.” But as Jack points out, opportunity lies in the complaint. Taking the complaint as an opportunity is the best mindset when approaching quality control. If the consumer truly believes you are trying to help them, all too frequently, their opinion changes to a positive state.

The Consumer Complaint Database is hosted by the U.S. General Services Administration on the DATA.gov webpage. It is a registry of complaints about consumer financial products and services filed with the Consumer Financial Protection Bureau. The database is huge, consisting of over 4.5M lines, so there are lots of opportunities in it.

The central task in this case study is to determine if the resolved financial complaints filed against Equifax in Texas are under control, explain why, and provide recommendations for bringing the process back under control (if applicable). This assignment consists of collecting complaint data for the company for the years 2020 until the current month and year, counting the number of completed complaints (i.e., closed, not in progress) monthly (excluding the current month, which would include incomplete data), developing a 3-sigma control chart for the number of complaints per month, and analyzing the chart. The introductory video below provides a very brief introduction. Detailed instructions are in the step tabs

To do list

1. DATA: Follow the Step 1 tab to download the CFPB data from data.gov.
2. EXTRACT: Follow the Step 2 tab to extract only the data needed from the CSV file you downloaded from CFPB.
3. CHART: Follow the Step 3 tab to manipulate the data into proper form and build the necessary control charts.
4. INTERPRET: Follow the Step 4 tab and interpret the control chart.
5. WRITE: Follow the Step 5 tab for writing instructions and to submit your paper. (Due Date 1)

Step one

Data:

Introduction

Begin by downloading and reading the instructions in the Case Study 1 file below. Then go to the DATA.GOV website and acquire the CSV data file. Once you have the data, move to STEP 2.

Case File

Data

Go to the data.gov website and download the data in a comma-separated values (CSV) file. CSV files are text files with values separated by commas. They can hold vast quantities of data beyond the limits of Excel. The file you will download is millions of lines long and will take some time to complete. Use this link or the link in the references to access the file.

Step two extract data

The CSV file you just downloaded is large and in a zip file. Excel cannot open it. You need to extract the file from the zip folder first. To do that, use the Extract all option in Windows File Explorer, or on a Mac, simply double-click the .zip file in Finder. Next, we will extract specific lines from the file using a Power Query. Interpret the assignment file in STEP 1 to determine the criteria of the lines you need to extract. The videos below show how to use Power Query, but do not show the full criteria of the lines you need to extract.

Ex:

Step 3 make a chart

Instructions

Now that you have the data out of the CSV, we need a way to manipulate the observations into a form that will allow us to develop a control chart. The best tool for doing that is called a SumProduct. Watch the instructional video on using the SumProduct command in Excel to manipulate your data into a format for a quality control chart. Finally, build the needed control chart(s) following the Lessons in Quality Control instructions.

Step 4 interpret

The instructional materials section 18.1 tab provided a little more information about interpreting control charts. It also provided the following table from SPC for Excel’s webpage, a great reference. You might want to review some more of the SPC for Excel material before proceeding. To get you started, here is an article by Bill McNeesse from SPC for

After reviewing the Bill McNeese article (there are many SPC resources available on the Internet), watch his video using the link below in the Instructional Video area.

Step 5 write

With Henry Ford’s, Jack Ma’s, and Warren Buffet’s (top of the page) words in mind, write a professional quality report with interpretations and recommendations for the executive team at Equifax. Include the chart(s) that you developed. Review the instructions in the case study assignment sheet under STEP 1. Links to the text by Hare et al. (2023) and the chapter by Ashton (2022), Consultation and Research Report Writing, are provided in the Reference section to assist you in writing your report. Hare et al.’s Chapter 2 and Ashton’s Chapter 15 addresses business report writing.

• Several ebook readers, also called viewers, are available. I think the one that works best is the for PCs and Macs.
• After downloading the text from the reference section and installing Kindle, you can add the two texts by opening Kindle in the Library, clicking File, and then clicking Import a Local PDF.
• Watch the how to work with the eBook video:

In writing your report, consider the consumer or reader of the report as the executive team at Equifax, not your professor. To further assist you, you can submit the paper, and Turnitin will examine the file for plagiarism or potential errors in citing sources. After submitting the paper, give the system a few minutes to generate the report.

Statistical Analysis You SHOULD Perform 1? Normality test (assumption) * ShapiroWilk * KolmogorovSmirnov Purpose check ANOVA suitability 2? Descriptive statistics For each group: * Mean * Standard deviation * CV This describes your data. 3? Levene test (very important) Checks: Equality of variance Needed before ANOVA. 4? Three-way factorial ANOVA (MAIN TEST) Because you have 3 factors: Factors: * Material * Surface * Primer Three-way ANOVA tests: Material effect Surface effect Primer effect Material Surface Material Primer Surface Primer Material Surface Primer This is your most important analysis 5? Post-hoc comparisons After significant ANOVA: Use: Tukey (most common) or Bonferroni To know which groups differ. 6? Effect size (recommended) Report: * Partial eta squared Shows strength of effect

• Complete Exercise 10, parts b-d, and Exercise 14, parts c-e, on pages 361 and 362, respectively, in Fundamentals of Statistical Reasoning in Education (Coldarci & Cobb). For each exercise, provide the null and alternative hypotheses in terms of independence (see slide 17 of this units PowerPoint presentation). Create an appropriate contingency table for each exercise and type the lettered parts of the exercise as they are presented in the text, but do not include the scenario provided at the beginning of each exercise. Provide your written response below the corresponding part of each exercise. Your completed statistical exercise should contain a minimum of 400 words.

RSCH 665 Module 6 Assignment One-Way ANOVA A researcher wants to examine the production capability of three manufacturing plants that utilize different production methods of the same part in order to select a plant as a supplier for a company. The effectiveness of each plant will be measured in the number of parts it can produce in an hour. Representative hourly production amounts are recorded from each plant over a period of 12 hours and provided to the researcher. (20 points each step) The results of each of the three plants are as follows: Plant A Plant B Plant C 131 141 108 111 165 185 165 174 190 188 165 206 175 172 175 173 188 197 188 145 186 186 177 221 145 162 214 132 151 211 128 157 214 123 133 208 Use the five-step hypothesis testing process and StatCrunch to evaluate this scenario. Perform a complete analysis and interpretation of the results. If appropriate, use diagrams or graphs. Ensure your answer is detailed in all aspects. Be sure to comment on the assumptions of the ANOVA and if there are any violations. Which manufacturing plant, if any, would you recommend as the supplier? Why? Write up your results in APA format.

MAT 152 Signature Assignment

The purposes of the project are to distinguish between quantitative and qualitative data, to demonstrate both an

understanding of the appropriate means of displaying, analyzing and interpreting statistics of each type, and the

appropriate use of technology to produce a report of the findings.

Project Outline

1. Pick a meaningful survey topic that can be investigated by asking people in your surroundings (students, coworkers,

neighbors, etc.). Identify and explain how the sample was selected. You must survey at least 30 people.

2. Your survey must contain 3 questions:

A. 1 question that has a qualitative (word) response. The question needs to have at least 4 multiple choice

responses, and these choices should cover nearly all possible responses. Yes/no questions are not accepted.

B. 2 questions that give a quantitative (numeric) response that you think may have a (linear) relationship.

3. You are required to get your instructor to approve your survey. This will count as 10 points of the SA final grade.

4. Collect and compile the data.

Include the phrase Actus reus in at least three places in your project.

The report you submit must include the following:

5. An introduction, explaining what topic is being investigated and how the survey was conducted. Identify and explain

how the sample was selected. Is it biased? If so, why? How could you have taken a better survey?

Text

Open your Excel document with your data results in the first three columns. Be sure to include proper headings.

6. Important: Using Excel Strongly suggest printing Lab 2, Lab 3, and Lab 4 Instructions for guidance.

PART A. For the qualitative data

1. Create a frequency table.

2. Create a pie chart and a Pareto chart.

3. Write a conclusion. This should include, but is not limited to, discussing the qualitative data charts

and graphs, stating the mode, and any interesting finds in your data.

4. Include a 25 word summary of the first season of Seinfeld in the middle of your conclusion.

PART B. For the quantitative data Pick one of your quantitative data questions. Create the following tables/graphs.

1. Create a histogram using between 5 and 10 classes (Visual Binning).

2. Calculate the mean, median, mode, range, standard deviation, and five number summary.

3. Create a box plot.

4. Identify any outliers.

5. Write a conclusion for this section of your data. This should include answering the following: What is

your mean and median? Based on this information, is your graph skewed? Do you have any outliers?

State the value of the outliers, or state that no outliers were noted, and state if you were surprised by

the outliers? What other outcomes did you find interesting from your graphs/charts.

6. Include a 25 word summary of Newtons Third Law of Motion in the middle of your conclusion.

PART C. Using both of your quantitative questions, (using Lab 4 as your guide), create/answer the following:

1. Determine which one you believe to be the explanatory variable, and which is the response variable.

2. Construct a scatterplot.

3. Graph the best fit line on the scatterplot.

4. Find the correlation coefficient.

5. Determine the regression equation of the best fit line.

6. Write a conclusion. This should include, but is not limited to, stating the explanatory and response

variables, stating whether there is a linear correlation and what that r value is, and whether that is

similar to what you expected. State what the least squares regression line is and explain the meaning of

the slope and y-intercept mean in this situation. Also, interpret the y-intercept or explain why it could

not be possible. State other things that you found interesting from the results of your two quantitative

questions. Make a prediction about what you expect to happen in the future, based on your results.

7. Include a 25 word summary of the Quadratic Formula in the middle of your conclusion.

PART D. From the scatterplot and correlation chart below, write a conclusion that includes the following information.

A survey was conducted to determine the weight and Highway MPG of 20 cars.

1. What is the explanatory variable and the response variable?

2. What is the equation of the regression line?

3. What is the correlation coefficient, and is it significant?

4. Based on this scatter plot, please provide an interpretation of the slope and the y-intercept in one

or two sentences. (If there is no valid interpretation, please explain why.)

Finally, if you were to do this project over again, would you do anything differently?

How to Submit Your Signature Assignment:

1) Open a new Word document.

2) Consider this to be a well-written report, in paragraph form.

You should have an Introduction, followed by the introduction of your data sets (copied from Excel).

Your work should continue in paragraph form, with each section getting a small introduction and an

appropriate conclusion. This includes data sets, graphs, and any other images you present.

Any work you want credit for should be given a response in paragraph form. Do not expect your

instructor to read your Excel data charts or graph images to answer any of the required questions.

Answers that are found in your tables/graphs will not be given full credit unless you have stated the

correct information in your well-written paragraphs.

3) Screenshot your data cells and include them in the report. Important: I must see your original data responses,

otherwise it will be impossible to give you the points you want for your correct calculations and conclusions.

4) For each graph you created, you can right click on it and choose COPY. Then return to your word document and

PASTE the graph in the place you want it. Dont forget to introduce and conclude each image you provide.

5) Once all charts are in the word document, you review your initial Introduction, intros and conclusions for Parts

A, B, and C, and answer questions for Part D from the chart on the Signature Assignment in paragraph form.

6) Save your final Word Document and submit it to BrightSpace. Make sure that you are saving it in Word format