0 Comments

Description

Sample, Instructions and Template are attached. I currently live in the state of California.

Sample and Template are attached. I currently live in the state of California.
You are an analyst at a new moving company. Executive leadership is trying to determine in
which state to headquarter the new business. Obviously, they are interested in setting up the
headquarters in a state that has the potential for significant business. In other words, they want a
location where there are a lot of people moving in and out of the state.
Your manager has asked you to begin the research process by comparing your current state of
residence to another state (of your choice) and then make a recommendation based on your
findings.
Requirements
Download the Population estimates for the U.S., States, and counties data set from the
Economic Research Service, linked below:

U.S. Department of Agriculture, Economic Research Service. (2017). Download data: Countylevel data sets. Retrieved from https://www.ers.usda.gov/data-products/county-leve…
Analyze the county-level population changes in your current state and another state of your
choice. Once you have analyzed this data, prepare a business analysis for your manager.
In your analysis, include the following:


Analyze the business issue you are addressing.
o Explain the business situation as you understand it.
o Identify relevant data (observations and variables) that you will use to address the
situation.
Justify your selection of an inferential method to address the business issue.
o Explain the inference you wish to make. (Hint: You can estimate, test, or predict. If your
selected inference is a prediction, identify what you are trying to predict and what you
are basing your prediction on. If your selected inference is an estimate, identify what
you are trying to estimate. If your selected inference is a test, identify the claim you are
attempting to test.)
o Identify the inferential statistical technique that would be the best tool to use for your
selected prediction, estimate, or test.
o Explain why you believe this would be the best tool for the situation. (Please note that
you are not required to compute anything, simply to identify the best tool and explain
why.)
o Provide examples from your experience and/or from your research to support your
selection of inferential statistical technique.
Deliverable Format
This business analysis is a professional document and should therefore follow the
corresponding MBA Academic and Professional Document Guidelines (available in the
MBA Program Resources), using double-spaced paragraphs. Remember, you are
writing for an executive leadership audience.
In addition, include the following:





3–4 pages in length.
Title page.
References page.
References from at least 2 sources.
APA-formatted references.
Evaluation
By successfully completing this assessment, you will demonstrate your proficiency in the
following course competencies through corresponding scoring guide criteria:



Competency 1: Explain how data management techniques and tools are used to support
business decisions.
o Analyze a business situation.
Competency 2: Use analytic and statistical techniques to make meaning of large quantities of
data.
o Justify the selection of an inferential method to address a business situation.
Competency 4: Present the results of data analysis in clear and meaningful ways to multiple
stakeholders.
o Correctly format citations and references using current APA style.
o Write content clearly and logically with correct use of grammar, punctuation, and
mechanics.
Running head: ANALYTIC METHODS PROPOSAL: MOVING COMPANY ANALYSIS
1
Analytic Methods Proposal: Moving Company Analysis
Test I. Student
Capella University
Author Note
This assessment is being completed to fulfill requirements for Assessment 2 in MBA-FPX5008.
ANALYTIC METHODS PROPOSAL: MOVING COMPANY ANALYSIS
2
Abstract
This project includes the proposal and justification of an inferential statistical technique as an
analytic method to address the business problem of attempting to find the best headquarters for a
moving company. This analysis will not cover all possible locations, but, as requested, will
focus on the comparison of two states and preparing for analysis and proposal of selection
between the two states being compared.
Keywords: moving company, headquarters, inferential technique, analytic methods,
proposal
ANALYTIC METHODS PROPOSAL: MOVING COMPANY ANALYSIS
3
Analytic Methods Proposal: Moving Company Analysis
A new moving company is attempting to select the optimal location for their moving
company’s new headquarters. The initial analysis will focus on two states, Puerto Rico and
Wyoming. This project will not conduct the analysis, but will, instead, propose a statistical
inferential technique, that will be used to conduct the analysis in future projects, and justify that
selection with similar examples and research.
Business Problem
A new moving company is being opened, and the executive leadership starting the
company would like to select the optimal location for their moving company’s new headquarters.
The analytics manager has asked the analyst to select two states for an initial comparison,
including the analyst’s home state, and a state of their choice. The two states that will be
compared in this analysis include Puerto Rico and Wyoming.
Data to be Used
The data used for this project will be the Population Estimates for the U.S., States and
counties, 2010-16 (Economic Research Service, 2017). To identify the data related to Puerto
Rico, all records with State = PR will be used, and to identify the data related to Wyoming, all
records with State = WY will be used. An assumption will be made that the moving company
has a preference for domestic moves, so both net migration (in fields NET_MIG_2010,
NET_MIG_2011, NET_MIG_2012, NET_MIG_2013, NET_MIG_2014, NET_MIG_2015, and
NET_MIG_2016) and domestic migration (in fields DOMESTIC_MIG_2010,
DOMESTIC_MIG_2011, DOMESTIC_MIG_2012, DOMESTIC_MIG_2013,
DOMESTIC_MIG_2014, DOMESTIC_MIG_2015, DOMESTIC_MIG_2016) will be reviewed
in this analysis, for both states.
ANALYTIC METHODS PROPOSAL: MOVING COMPANY ANALYSIS
4
Analytic Methods
Although there are multiple ways to address this problem or to begin to look at the
problem, and only one method is required, the author is proposing the use of three different
inferential statistical methods to get a better idea of all the aspects relating to migration for these
states to enable an informed decision for the company. The first two proposed methods include a
paired t-test hypothesis testing for a difference between net migration for Puerto Rico and
Wyoming and a paired t-test hypothesis test for a difference between domestic migration for
Puerto Rico and Wyoming. The paired t-test hypothesis test on net migration would test if the
mean of the annual differences in net migration from 2010 to 2016 between Puerto Rico and
Wyoming are equal to 0 vs that they are not equal to 0. The paired t-test hypothesis test on
domestic migration would test if the mean of the annual differences in domestic migration from
2010 to 2016 for Puerto Rico and Wyoming are equal to 0 vs that they are not equal to 0. In
addition, the third method that is being proposed is to use simple linear regression to attempt to
predict the domestic migration for 2017 for each state, based on the domestic migration over the
past 7 years of data.
Inferential Statistical Technique Proposal
A paired t-test is used when there are pairs of values and it is desired to determine if the
average of the differences is 0, or, in other words, if the difference in the pairs averages out to 0
(Bowerman, 2016). We have net migration and domestic migration data for both states over the
same 7 years (2010 to 2016). With this, the net migration by state will be paired by year, the
domestic migration will be paired by year, and two separate paired t-tests will be conducted for
the differences.
ANALYTIC METHODS PROPOSAL: MOVING COMPANY ANALYSIS
5
Simple linear regression is a method used to predict one quantitative variable based on
another quantitative variable, sometimes time (although there are a set of methods dedicated to
basing predictions on time-based variables, called time series analysis) (Bowerman, 2016). To
attempt to predict the domestic migration for 2017 for each state based on that state’s domestic
migration for 2010-2016, the inferential method of simple linear regression is being proposed to
be used.
Inferential Statistical Technique Justification
Since we have two sets of data that are tied together, or paired, by date, a paired t-test is
appropriate (for both hypothesis testing situations) (Bowerman, 2016). Although our sample size
for both the paired t-tests is small (7 years), researchers have suggested that it might still be ok to
use a t-test on small samples, even those less than or equal to 5 (De Winter, 2013). De Winter
(2013) recommends, however, that “researchers should always judge the credibility of their
findings and should remember that extraordinary claims require extraordinary evidence” (p. 8).
An example of a paired t-test application in business is in comparing the ratings of importance vs
performance of hotels on specific attributes of travel, like “attractiveness of the program” or
“price/quality relationship,” for example (Johann, 2014, p. 575).
To attempt to predict the 2017 domestic migration for each of the states, simple linear
regression is being proposed. Other methods, like multiple linear regression and logistic
regression are used for prediction, but since we are looking to predict one quantitative variable
(domestic migration) based on another quantitative variable (year, which is the only predictor we
have for each state in the current dataset), we will use simple linear regression (Bowerman,
2016). Along the same topic of application as Johann’s (2014) testing of the paired differences
between importance and performance, an example of an application of simple linear regression
ANALYTIC METHODS PROPOSAL: MOVING COMPANY ANALYSIS
6
in the hotel service industry is the prediction of performance based on importance (Chen & Chen,
2014).
Conclusion
In conclusion, to address the business problem of attempting to find a state to start the
new moving company (i.e. to create the company headquarters) in, three different sets of
analyses will be conducted to compare the migration to and from the states or territories of
Puerto Rico and Wyoming. The first of these methods is a paired t-test to test the hypothesis that
the average of the differences in net migration between the states across the years 2010-2016 is
equal to 0 versus the hypothesis that the average of the differences in net migration between the
states across the years 2010-2017 is not equal to 0. The second of these methods is a paired t-test
to test the hypothesis that the average of the differences in domestic migration between the states
across the years 2010-2016 is equal to 0 versus the hypothesis that the average of the differences
in domestic migration between the states across the years 2010-2016 is not equal to 0. The third
of these methods is simple linear regression to predict the domestic migration for each state in
2017 using an equation for each state that predicts domestic migration based on year.
ANALYTIC METHODS PROPOSAL: MOVING COMPANY ANALYSIS
References
Bowerman, B. (2016). Business statistics in practice: Using data, modeling, and analytics (8th
ed.). New York, NY: McGraw Hill.
Chen, K. S., & Chen, H. T. (2014). Applying importance–performance analysis with simple
regression model and priority indices to assess hotels’ service performance. Journal of
Testing and Evaluation, 42(2), 455–466.
De Winter, J. C. (2013). Using the student’s t-test with extremely small sample sizes. Practical
Assessment, Research & Evaluation, 18(10).
U.S. Department of Agriculture, Economic Research Service. (2017). Download data: Countylevel data Sets. Retrieved from https://www.ers.usda.gov/data-products/county-leveldata-sets/county-level-data-sets-download-data/
Johann, M. (2014). The importance-performance analysis: an evaluation of tourist satisfaction
with the destination attributes. International Journal of Economic Practices and
Theories, 4(5), 572–578.
7
Running head: [SHORTENED TITLE UP TO 50 CHARACTERS]
[Title Here, up to 12 Words, on One to Two Lines]
[Author Name(s), First M. Last, Omit Titles and Degrees]
[Institutional Affiliation(s)]
Author Note
[Include any grant/funding information and a complete correspondence address.]
1
[SHORTENED TITLE UP TO 50 CHARACTERS]
Abstract
[The abstract should be one paragraph of between 150 and 250 words. It is not indented.
Section titles, such as the word Abstract above, are not considered headings so they don’t use
bold heading format. Instead, use the Section Title style. This style automatically starts your
section on a new page, so you don’t have to add page breaks. Note that all of the styles for this
template are available on the Home tab of the ribbon, in the Styles gallery.]
Keywords: [Click here to add keywords.]
2
[SHORTENED TITLE UP TO 50 CHARACTERS]
3
[Title Here, up to 12 Words, on One to Two Lines]
[A high-level introduction to the paper should go here. Include an overview of the
business problem that project is attempting to address, as well as the sections that will be covered
below in proposing (and supporting) the analytic, inferential, methods to address this problem.]
[Business Problem]
[Explain the business problem this project is attempting to address, as it is currently
understood, and summarize the requested starting point for the analysis (i.e. the request by the
manager to compare two states – the one you live in and another of your choice).]
[Data to be Used]
[In this section, identify the criteria for inclusion in the analysis (i.e. the states that are being
compared), the fields and variables that will be used in the analysis, and any summary
measurements that will be used in the analysis.]
[Analytic, Inferential Methods]
[Explain the inference that you wish to make to address the business problem. (Hint: you
can estimate test or predict. If your selected inference is a prediction, identify what you are
trying to predict and what you are basing your prediction on. If your selected inference is an
estimate, identify what you are trying to estimate. If your selected inference is a test, identify the
claim you are attempting to test.]
[Inferential Statistical Technique Proposal]
[In this section, identify the inferential statistical technique that would be the best tool to use for
your selected prediction, estimate, or test. Explain what the technique is used for and provide
examples of applications of the technique.]
[SHORTENED TITLE UP TO 50 CHARACTERS]
4
[Inferential Statistical Technique Justification]
[In this section, explain why you believe this would be the best tool for the situation. (Please
note that you are not required to compute anything, simply to identify the best tool and explain
why.) Provide examples from your experience or from your research to support your selection of
inferential statistical technique.]
[SHORTENED TITLE UP TO 50 CHARACTERS]
References
Last Name, F. M. (Year). Article Title. Journal Title, Pages From – To.
Last Name, F. M. (Year). Book Title. City Name: Publisher Name.
5

Purchase answer to see full
attachment

Order Solution Now

Categories: