Instructions
Final 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 Mercer Human Resource Consulting website 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.
https://mobilityexchange.mercer.com/Insights/ cost-of-living-rankings#rankings
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 ¾ 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. How to Write an Executive Summary That Gets the Job Done 2023.pdf
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?
Category: Mathematics
-
“Expanding Internationally: A Data-Driven Approach to Selecting a New Location for a Marketing Company”
-
Title: Improving Customer Order Process Efficiency and Accuracy
All answers in a word document plus an excel document for graphs where necessary
Important Info
The order was placed through a short procedure (customer skipped some order details).
Please clarify some paper details before starting to work on the order.
Type of paper and subject
Number of sources and formatting style
Type of service (writing, rewriting, etc) -
“Geometry Course Completion with Guaranteed B+ or Above Grade”
This geometry course is 2 semesters worth of work, and needs to be done between the 17th of June and the 23rd of July. You would just be completing the course for me, as I am a busy person and do not have the time to complete it myself. Please get me a grade of AT LEAST a B+ or above. Thanks!
-
“Statistical Analysis Using Jamovi: Exploring Data Sets 21 and 22”
The instructions for the assignment can be found in a pdf file below. For this assignment, a Jamovi app must be used to solve the problems as well as the data sets named data21
and data 22. -
Title: Exploring the Correlation between Internet Usage and School Grades in Mathematics
Please write my maths internal assessment for tonight. My topic is “Correlation between internet usage and school grade.” I did a survey asking the students in my school “What is your class”, “How many hours of screen time do you have accumulated on your phone in a week (average)?”, “What final grade did you get in maths? (Average of all bimestres)”, “Did you pass in all of them?”(recuperação is a Portuguese word and it means not passing) and If they didn’t pass in any of them, how many times? I’ll send the survey with the data collected and my hypothesis is that the higher the use of internet, the lower the grades. Also, CLASSES THAT ARE 10, THEIR MAXIMUM GRADE IS 7 SINCE THEY ARE IN IB!!!
-
“The Scarecrow’s Mathematical Wisdom and Other Examples of Math in Popular Culture” The Scarecrow’s Mathematical Wisdom and Other Examples of Math in Popular Culture In the 1939 movie The Wizard of Oz, the Scarecrow proudly ex
In the 1939 movie The Wizard of Oz, upon being presented with a Th.D. (Doctor of Thinkology), the Scarecrow proudly exclaims, “The sum of the square roots of any two sides of an isosceles triangle is equal to the square root of the remaining side.” Analyze the statement made by the Scarecrow. Present your analysis and give a complete description of the triangles that satisfy the statement.
Find another example of math being used in:
Movies, television, popular culture, art, music and harmonics, scientific research papers, newspapers or magazine articles, nature and natural phenomena, voting, national security, manufacturing, logistics, transportation, healthcare, business, economics, or some noteworthy or pivotal historical moment.
Research and explain whether or not the math was used correctly.
It can be short and sweet!!!!!!!! -
“Solving Circuits with Laplace Transform: A Powerful Tool for Differential Equations” A. Abstract: Differential equations are an essential mathematical tool used to model and solve real-world problems in various fields. However, solving these equations can be challenging
Subject: Application of Differential Equation
Description: Pick the math topic that we learned in class, and research it. Please include abstract, introduction, methodology (Proof of equation and show the method), conclusion, and references.
Follow the MLA style, and provide the references.
Instruction:
A. Abtract:
Big picture problem or topic widely debated in your field.
The gap in the literature on this topic. Your project filling the gap.
The specific material that you examine in this project. Your original argument (hypothesis). Strong concluding sentence.
B. Introduction:
Big picture about Differential Equation and their application on the topic that you choose.
Explain the Laplace Transform equation (provide the equation and explain the term)
C. Methodology
Show the equation and how it involves into the topic that you choose.
Show the data and any graph relate to equation.
Explain why using this equation can solve the problem.
Show the step by step.
D. Conclusion
Summary the topic and how the equation can help you relate to the topic that you choose.
Please see the sample to understand more.
Topic: Using the Laplace transform to solve the circuit
Resource and Proof of equation
hsu-Chapter 6 Laplace transform.pdf (sjsu.edu)
Thiagarajan.pdf (uchicago.edu) (Page 5)
You can use other outside resources. -
“Optimizing Performance in the Shipping and Trade Industry: A Comprehensive Report on Operation Research Methodologies”
This is a 12-page report on the set topics I will provide.
The class is operation research. The purpose of this class is to find optimal performance within the shipping and trade industry. What you must do is go through each topic and go into depth on it. Along with that what is key is to figure out the methodology. In a sense Display your knowledge of the “math” of the topic.
Operation research is a very simple math, but very methodical. You can add charts and graphs to help describe it.
I will attach two essays, which are basically the same thing, but on a smaller scale. This can help with your guidelines. I will also upload notes on each topic for you to look at if that helps. Lastly, I will upload the document of all the topics. There are 13 topics so a page or two each will be more than enough.
Please feel free to ask me any questions. -
Statistical Analysis: Correlations, Comparisons, and ANOVA Tests
Use data_21 for the following tasks.
1) I want to see the relationship between “Total hours a week your partner spends on
housework” (phwwkhs) and “Total hours a week you personally spend on housework”
(hwwkhs) using correlations.
a. Set up the hypotheses.
b. Choose the appropriate correlation metric to use (use graphical methods and
numerical tests etc.).
c. Interpret the outcome of the correlation type chosen to evaluate the relationship
between the two variables. (Write a clear and complete sentence)
Compare the total number of years in full-or part time work (yrspdwka) between genders.
a. Set up the hypotheses.
b. Decide on which test is most appropriate for this comparison.
c. According to the output draw conclusions on whether there are significant differences
between the groups and answer your hypotheses. (Write a clear and understandable
sentence)
Compare the variables “Total number of years in full-or part time work” (yrspdwka) and the
“Years of full-time education completed” (eduyrs).
a. Set up the hypotheses.
b. Decide on which test is most appropriate for this comparison.
c. According to the output draw conclusions on whether there are significant
differences between the groups and answer your hypotheses. (Write a clear
and understandable sentence)
You would like to compare “the importance to care for nature and environment” (Variable:
impenv), “the importance to follow traditions and customs” (Variable: imptrad) and “the
importance to seek fun and things that give pleasure” (Variable: impfun).
a. Set up the hypotheses.
b. Decide on which test is most appropriate for this comparison.
c. According to the output draw conclusions on whether there are significant
differences between the groups and answer your hypotheses.
d. If there are significant differences, perform post-hoc tests and draw a conclusion.
2)Use data_22 for the following tasks.
Compare the variable “GDP per capita” (GDPCAPITA) across the three groups of the variable
“Fertility rate, total” (FERTILITY). Hint: You need to categorize FERTILITY variable into three
categories: low (fertility rate <= 2.5), Medium (fertility rate <= 4.5) and high (for else). Use the transform option to create new variable. a. Set up the hypotheses. b. Decide on which test is most appropriate for this comparison. c. According to the output draw conclusions on whether there are significant differences between the groups and answer your hypotheses. d. If there are significant differences, perform post-hoc tests and draw a conclusion. We want to evaluate the effect of two independent variables, Fertility (the categorized one in task 5) and Inflation (categorize it into two levels, low ( 5)) on the dependent variable GDP per capita (GDPCAPITA). a. Draw a design for two-way ANOVA and set up all possible hypotheses. b. Decide whether this design is useful or not (Check the assumptions of this design). c. Analyze the main output of this test and perform the post hoc test if needed and draw your conclusions. d. Do some search and find out what are the better alternatives to this model design. -
Exploring Relationships and Comparing Variables: An Analysis of Data_21 and Data_22
Use data_21 for the following tasks.
1. I want to see the relationship between “Total hours a week your partner spends on
housework” (phwwkhs) and “Total hours a week you personally spend on housework”
(hwwkhs) using correlations.
a. Set up the hypotheses.
b. Choose the appropriate correlation metric to use (use graphical methods and
numerical tests etc.).
c. Interpret the outcome of the correlation type chosen to evaluate the relationship
between the two variables. (Write a clear and complete sentence)
2. Compare the total number of years in full-or part time work (yrspdwka) between genders.
a. Set up the hypotheses.
b. Decide on which test is most appropriate for this comparison.
c. According to the output draw conclusions on whether there are significant differences
between the groups and answer your hypotheses. (Write a clear and understandable
sentence)
3. Compare the variables “Total number of years in full-or part time work” (yrspdwka) and the
“Years of full-time education completed” (eduyrs).
a. Set up the hypotheses.
b. Decide on which test is most appropriate for this comparison.
c. According to the output draw conclusions on whether there are significant
differences between the groups and answer your hypotheses. (Write a clear
and understandable sentence)
4. You would like to compare “the importance to care for nature and environment” (Variable:
impenv), “the importance to follow traditions and customs” (Variable: imptrad) and “the
importance to seek fun and things that give pleasure” (Variable: impfun).
a. Set up the hypotheses.
b. Decide on which test is most appropriate for this comparison.
c. According to the output draw conclusions on whether there are significant
differences between the groups and answer your hypotheses.
d. If there are significant differences, perform post-hoc tests and draw a conclusion.
Use data_22 for the following tasks.
5. Compare the variable “GDP per capita” (GDPCAPITA) across the three groups of the variable
“Fertility rate, total” (FERTILITY). Hint: You need to categorize FERTILITY variable into three
categories: low (fertility rate <= 2.5), Medium (fertility rate <= 4.5) and high (for else). Use the transform option to create new variable. a. Set up the hypotheses. b. Decide on which test is most appropriate for this comparison. c. According to the output draw conclusions on whether there are significant differences between the groups and answer your hypotheses. d. If there are significant differences, perform post-hoc tests and draw a conclusion. 6. We want to evaluate the effect of two independent variables, Fertility (the categorized one in task 5) and Inflation (categorize it into two levels, low ( 5)) on the dependent variable GDP per capita (GDPCAPITA). a. Draw a design for two-way ANOVA and set up all possible hypotheses. b. Decide whether this design is useful or not (Check the assumptions of this design). c. Analyze the main output of this test and perform the post hoc test if needed and draw your conclusions. d. Do some search and find out what are the better alternatives to this model design.