Capella MBA6018 unit 1 assignment latest 2016 july

Producing
and Interpreting Descriptive Statistics

Activity
Instruction

For
this assignment, you will need to access the Florida Pool Data document, posted
in in Updates and Handouts.

For
this practical application assignment, imagine that you are a real estate agent
living and working in southern Florida. The senior real estate partner of your
firm e-mails you a document containing Florida pool home data and asks you to
find ways to describe the most important aspects of the home sale data. This
technique is called descriptive statistics. The file contains data for 80
properties, including home prices, home sizes, number of bathrooms, niceness
ratings, and whether or not there is a pool. This file is used as an example on
pages 142–143 ofBusiness Statistics in Practice.
If you are using Excel, read Appendix 2.1 on pages 80–87 in your textbook,
which provides instruction on how to construct a frequency distribution,
histogram, and scatter plot in Excel. SAS users can reference the SAS tutorials
located in the third study activity of this unit.

Compute
the following data parameters:

1.
Calculate the mean, median, range, and standard deviation of home
price and size. For the assignment document, copy and paste the output (graph)
from the Excel Analysis ToolPak or SAS Enterprise Guide into a Word document.
Then cut and paste that spreadsheet into a Word document. Be sure to verbally
summarize your data findings in four or five sentences that will help a home
buyer make a purchasing decision in the Florida real estate market.

2.
Calculate the mode for the number of bathrooms. You can cut and
paste the answers from the Excel Analysis ToolPak or SAS Enterprise Guide. Then
verbally summarize this data to help a buyer make a purchasing decision in the
Florida real estate market.

3.
Produce a histogram that shows the number of houses by price
range, in increments of $50,000 (for example, $0–$50,000; $50,001–$100,000 and
so on). Then verbally summarize how this histogram will help a buyer make a
purchasing decision in the Florida real estate market.

4.
Produce a scatter plot showing the relationship between price and
home size. In a cell under your scatterplot, indicate whether the relationship
is positive or negative and whether the results are what you expect. Then
verbally summarize how this scatter plot output will help a buyer make a
purchasing decision in the Florida real estate market.

Assignment
Submission

Compile
all of your answers in a single Microsoft Word file (submitted as a .docx
file), pasting in the tables and graphics you created to demonstrate your work.
Cearly title your tables and graphics, including each row and column. For
example, for the table in question 1, you might use the following labeling: Row
1, Column B contains the “Mean of Home Selling Prices,” Row 1, Column
C contains the “Mean of Home Size in Square Feet,” and so on.
Highlight the results of your data calculations within each table.

Submit
your report to the assignments area for grading. Please note that assignments
must be submitted to the assignments area for grading. Work e-mailed or
otherwise presented cannot be graded in accordance with Capella Grading
Standards. Because of the nature of statistics-based assignments, your
instructor cannot give feedback on drafts of your work. Instead, if you have
questions as you complete assignments, you are encouraged to attend the weekly
supplementary instruction sessions or to consult the archived sessions for
suggestions. Refer to the scoring guide prior to submission to ensure you meet
all evaluation criteria.

Assignment
Solutions

Each
week, after your unit assignments are graded, solution sets will be posted in
the Updates and Handouts section for your review. Be sure to compare your work
to the posted solutions, as the review is an important part of the learning
process.

Capella MBA6018 unit 2 assignment latest 2016
july

Estimating
From Samples

Resources

For
this assessment, you will need to use SAS Enterprise Guide or the Excel
Calculators, the latter of which can be found in Resources. SAS users can
reference the SAS tutorials located in the third study activity of Unit 1. For
this assignment, you will practice applying inferential statistical analysis to
two business decision scenarios. Complete both of the following scenarios.

Practical
Application Scenario 1

To
complete this scenario, use SAS Enterprise Guide or the Confidence Interval
Calculator and the Area Gas Prices document, provided in Updates and Handouts.

TheStar
Tribunenewspaper has
decided to write an article about gasoline prices in the Twin Cities area
(Minneapolis and St. Paul, Minnesota). The newspaper has designed a survey and
taken a simple random sample of regular unleaded gas prices at 70 area
stations. The results are in the Area Gas Prices file. The newspaper’s policy
is that no data will be reported unless they are 95 percent confident that the
numbers are correct. As the new manager of the data verification unit at theStar
Tribune, you need to develop a 95 percent confidence interval for
the average price of regular unleaded gasoline in the Twin Cities area.

You
already know how to compute sample parameters, like the sample mean and sample
standard deviation; this scenario simply asks you to complete a confidence
interval for the data provided and communicate the results to theStar
Tribune‘s business manager.

Practical
Application Scenario 2

To
complete this scenario, use the Sample Size Estimator file provided in
Resources.

The
third shift at the Microsoft’s Windows security unit in Redmond, Washington is
considering replacing its coffee brewing units with new German-made brewers. As
the newest member of this elite Microsoft team, you have been assigned to
investigate this proposal. Develop a 99 percent confidence interval for the
average yield (cups per pound) for the new German coffee brewer. The margin of
error should be no bigger than 0.3 (three tenths of a cup). Based on experience
with the current coffee makers, your best guess for the population standard
deviation, sigma, is 1.2 cups. How big of a sample do you need? Calculate the
estimated sample size needed for the above scenario and communicate your
findings to the business manager.

Assignment
Submission

Compile
the two practical application scenario answers into one Word file (submitted as
a .docx file) and copy the Excel or SAS output into that document. Highlight
your numerical answers for both practical applications scenarios in yellow, and
then right after that numerical solution, be sure to summarize your findings in
a three- to five-sentence paragraph to the scenario manager.

Submit
your report to the assignments area for grading. Please note that assignments
must be submitted to the assignments area for grading. Work e-mailed or
otherwise presented can not be graded in accordance with Capella Grading
Standards. Because of the nature of statistics-based assignments, your
instructor cannot give feedback on drafts of your work. Instead, if you have
questions as you complete assignments, you are encouraged to attend the weekly
supplementary instruction sessions or to consult the archived sessions for
suggestions. Refer to the scoring guide prior to submission to ensure you meet
all evaluation criteria.

Assignment
Solutions

Each
week, after your unit assignments are graded, solution sets will be posted in
the Updates and Handouts section for your review. Be sure to compare your work
to the posted solutions, as the review is an important part of the learning
process.

Capella MBA6018 unit 3 assignment latest 2016
july

Hypothesis
Testing Using One Sample

For this assessment, you will need to access the following documents:

• Hypothesis
  Tester – Single Sample, located in Resources.
• MOE
  Interviews, located in Updates and Handouts.

For this practical application assignment, you will assume the role of two
different managers to recommend a course of action by applying hypothesis
testing to business decisions. For the first scenario, you work for a
regionally based magazine publisher, and for the second, you have just been hired
away from your buyer’s position at Macy’s to work for the local mall.

You will need to use the Hypothesis Tester – Single Sample document to
complete both of the scenarios. You may also want to review the SAS One Sample
T-Testtutorial, also located in the
Resources.

Practical
Application Scenario 1

In 2010,Playbill Magazinecontacted Boos Allen to determine the
mean annual household income of its readers. Using a list of customers provided
byPlaybill, Boos Allen randomly sampled 300Playbillcustomers. From that
sample, Boos Allen is confident that the population averagePlaybillreader’s household income is $119,155
and has a population sample household income standard deviation of $30,000.

Recently, twoPlaybillexecutives suggested thatPlaybill‘s reader mean
average household income has increased and that the magazine’s price should be
raised. AsPlaybill‘s
new marketing manager, you convincePlaybill‘s
chief operating officer to complete a second survey with Boos Allen to confirm
that assertion. Yesterday, the new Boos Allen report appeared on your desk.
From another sample ofPlaybillcustomers
taken from a recent list you sent Boos Allen, the 2012Playbillcustomer’s profile is a mean annual
household income of $124,450 with a population standard deviation of household
income unchanged at $30,000.

You realize that even though you do not have thePlaybillreader population standard deviation,
you do have enough data to perform a one sample hypothesis test. In order to
choose the correct statistical tool to complete this assignment, consider the
following questions:

• What do
  you know about the population being studied (for example, do you know the
  standard deviation of that entire population)?
• What do
  you know about the sample of the population you took (for example, which
  sample statistical parameters do you have—mean, standard deviation,
  variance, and so on)?

Complete the following for this assignment:

1. Determine
   the null hypothesis, via both an explanation and a math equation.
2. Determine
   the alternative hypothesis, via both an explanation and a math equation.
3. Determine
   whether to accept or reject the null hypothesis. You may solve the
   equation manually, use the Hypothesis Tester – Single Sample file provided
   in Resources, or use the SAS Enterprise Guide. You may also use the
   Hypothesis Testermultimedia
   piece provided in Resources to review the process for this equation.
4. Determine
   if the p-value indicates acceptance or rejection of the null. Use alpha =
   .05
5. Report
   the rejection or acceptance of the null in terms of the scenario results.
   For this scenario, write a three-sentence paragraph that details why you
   can be statistically confident that the mean householdPlaybillreader’s
   income has increased, decreased, or remained the same, and what would
   happen if alpha was .01.

Practical
Application Scenario 2

In this practical application scenario, you have just been hired away from
the Macy’s linen department buyer position by the Mall of Elbonia (MoE), as the
new food court manager. Why? Rumor had it you just earned your MBA. One week
ago, the MoE conducted convenience interviews in the mall’s food court. One
hundred interviews were gathered. The results are summarized in the document
titled MoE Interviews, provided in the Updates and Handouts section.

In examining the interview results, you find that each customer is listed in
a row and each column contains data on:

• The
  customer’s gender. If you need this data, use the coding convention: 0 for
  female, 1 for male.
• How much
  time the customer spent in the mall.
• How much
  money he or she spent on food.
• The
  customer’s rating of the mall’s friendliness and attractiveness.

After applying the descriptive data measures, the mean is particularly
telling; you believe that you can happily tell the food court owners that the
average amount mall customers spend on food during a visit has increased. A
2011 study found that customers spent an average of $18.75 per visit. You
realize this is a one sample test of hypothesis situation. Use the data in the
MoE Interviews document and the following outlined process to be certain that
your assertions are correct and that the average amount mall customers spend on
food during a visit to your mall has increased.

1. Determine
   the null hypothesis, via both an explanation and a math equation.
2. Determine
   the alternative hypothesis, via both an explanation and a math equation.
3. Determine
   whether to accept or reject the null hypothesis. You may solve the
   equation manually or use the Hypothesis Tester – Single Sample document
   provided in the Resources or by using SAS Enterprise Guide.
4. Determine
   if the p-value indicates acceptance or rejection of the null. Use alpha =
   .05.
5. Report
   the rejection or acceptance of the null in terms of the scenario results.
   For this scenario, write a three-sentence paragraph that details why you
   can be statistically confident that the average amount a food court
   customer spends has increased, decreased, or remained the same, and what
   would happen if alpha was 0.01 or 0.1.

Assignment
Submission

Compile both of your scenario answers into one Word file (submitted as a
.docx file) and copy the Excel output (or other computer application output
that you used), including any graphics, tables, and so on, into that Word
document.

Submit your report to the assignments area for grading. Please note that
assignments must be submitted to the assignments area for grading. Work
e-mailed or otherwise presented cannot be graded in accordance with Capella
Grading Standards. Because of the nature of statistics-based assignments, your
instructor cannot give feedback on drafts of your work. Instead, if you have
questions as you complete assignments, you are encouraged to attend the weekly
supplementary instruction sessions or to consult the archived sessions for
suggestions. Refer to the scoring guide prior to submission to ensure you meet
all evaluation criteria.

Assignment
Solutions

Each week, after your unit assignments are graded, solution sets will be
posted in the Updates and Handouts section for your review. Be sure to compare
your work to the posted solutions, as the review is an important part of the
learning process.

Capella MBA6018 unit 4 assignment latest 2016
july

Comparing
Populations Using Statistical Inference

Resources

For this assignment, you will practice applying statistical inference to
business decision scenarios.

In order to complete this assignment, you will need to use statistical
analysis software. Refer to the third study activity in Unit 1 to ensure you
have all the necessary software to do so.Note:
For Excel 2011 for Mac, you must have the Microsoft Office for Mac 2011 update
14.1 installed, issued August 2011. Solver is included as part of the update.
After confirming that the update is installed, refer to steps 1–4 in thisMicrosoft
Office forumto activate the
Solver.

In addition, you will need to access the following documents:

• Golf
  Ball Distances, located in Updates and Handouts.
• Mall
  Time Results, located in Resources.

Practical
Application Scenario 1

You are the manager of the Gander Mountain store in Frogtown, Illinois.
Recently, a customer mentioned they believed your prices for ammunition were
lower than the prices of Gander Mountain’s primary competitor in hunting
equipment, Cabela’s. You would like to include that statement in a forthcoming
print advertisement, so you need statistical evidence to support this
assertion.

Identify the null and alternative hypotheses needed to test the contention.
Then identify the most appropriate sample selection technique to gather data
for testing the hypotheses. What statistical test should you use to accept or
reject this hypothesis using the data you will collect?

Practical
Application Scenario 2

Your love of golf has brought you back to the range as the new product
manager for UniDun’s Straight Flight (SF) line of golf balls. The company’s
research and development group has been experimenting with dimple patterns that
promote straight flight and feel they have achieved some degree of success;
however, you are worried about the effect that the new pattern might have on
driving distance.

The Golf Ball Distances document contains test results that compare the
driving distances for the two different kinds of balls: 40 balls of the new SF
type and 40 of the current UniDun type. Your job is to determine if the current
UniDun balls can be driven further than the new SF balls. To resolve this
question, you need appropriate answers to the following four questions.
Remember to use yourBusiness
Statistics in Practicetextbook,
the supplementary instruction session archives, and the optional course
resources to help you answer each of the following questions:

1. Identify
   the appropriate null and alternative hypotheses for this test. Express
   each in writing and in the form of an equation.
2. Identify
   the appropriate statistical test to accept or reject the null hypothesis.
3. Calculate
   the statistical parameters, the mean, variance, and standard deviation.
   Then calculate the statistical test and the p-value.
4. In a
   three- to five-paragraph synopsis, explain your results to the vice
   president of marketing, including the terms of the scenario variables.

Hint: You will need to use Excel’s Analysis ToolPak, or the Mac equivalent,
StatPlus:mac, to calculate the statistical parameters, the mean, variance, and
standard deviation, and to calculate the statistical test that you have chosen
and its p-value. SAS Enterprise Guide users do not need to first calculate the
statistical parameters.

Practical
Application Scenario 3

As the food court manager at the Mall of Elbonia, you must determine how
much time customers spend at the mall during different times of the week (for
example: midweek day; midweek evening; weekend day; weekend evening). Last
week, the mall survey staff randomly surveyed mall visitors as they left the
mall. One key question asked how much time the customer had spent in the mall
on that day.

The findings from this study are provided in the document titled Mall Time
Results, provided in Resources. Columns A through D show the time spent by the
customers interviewed, according to the part of the week and time of day when
the interviews occurred. Is there any statistically significant difference (at
alpha = .05) in the average amount of time people spend in the mall based on
the part of the week and time of day? To determine the answer to this question,
you need appropriate answers to all of the following four questions. Remember
to use yourBusiness
Statistics in Practicetextbook, the supplementary instruction session
archives, and the optional course resources to help you answer each question.

• Identify
  the null and alternative hypotheses you should form for this test. Express
  each in writing and also in equation form.
• Identify
  the appropriate statistical test to accept or reject the null hypothesis.
• Calculate
  the appropriate statistical test values to accept or reject your null and
  alternative hypotheses.
• What
  should you tell the Mall of Elbonia’s food court stores managers in terms
  of the mall’s high-traffic times and customer tendencies?

Assignment
Submission

Compile all of your practical application scenario answers into one Word
file (submitted as a .docx file). Copy the Excel or SAS output, including
graphics, tables, and so on, into that document. Highlight your findings for
these practical applications scenarios in yellow. Submit the file in the
assignments area for grading and instructor feedback. Prior to submission,
review the eleven questions within the three scenarios as well as the scoring
guide to ensure you meet all evaluation criteria.

Submit your report to the assignments area for grading. Please note that
assignments must be submitted to the assignments area for grading. Work
e-mailed or otherwise presented cannot be graded in accordance with Capella
Grading Standards. Because of the nature of statistics-based assignments, your
instructor cannot give feedback of drafts of your work. Instead, if you have
questions as you complete assignments, you are encouraged to attend the weekly
supplementary instruction sessions or to consult the archived sessions for
suggestions.

Assignment
Solutions

Each week, after your unit assignments are graded, solution sets will be
posted in the Updates and Handouts section for your review. Be sure to compare
your work to the posted solutions, as the review is an important part of the
learning process.

Capella MBA6018 unit 5 assignment latest 2016
july

Data
Gathering and Analysis

Resources

For
this assignment, you will examine the use of qualitative data for a business
scenario.

Review
Cooper and Schindler’s 2008 article, “Starbucks, Bank One, and Visa Launch
Starbucks Card Duetto Visa,” located in Resources, and address the
following components in your assignment:

• Answer
  discussion questions 2 and 4 at the end of the case.
• Describe any
  ethical issues that should concern Starbucks about this initiative.
• Summarize the
  use of qualitative data to support business decision making. Consider
  different types of qualitative data collection and analysis methods and
  the ways in which they can support business decision making and
  strategies.

Assignment
Submission

Create
all of your answers in a single Microsoft Word file (submitted as a .docx
file). Be sure to include graphs or tables where helpful and make sure all of
your final answers address all parts of this scenario.

Submit
your report to the assignments area for grading. Please note that assignments
must be submitted to the assignments area for grading. Work e-mailed or
otherwise presented cannot be graded in accordance with Capella Grading
Standards. Because of the nature of statistics-based assignments, your
instructor cannot give feedback on drafts of your work. Instead, if you have questions
as you complete assignments, you are encouraged to attend the weekly
supplementary instruction sessions or to consult the archived sessions for
suggestions. Refer to the scoring guide prior to submission to ensure you meet
all evaluation criteria.

Assignment
Solutions

Each
week, after your unit assignments are graded, solution sets will be posted in
the Updates and Handouts section for your review. Be sure to compare your work
to the posted solutions, as the review is an important part of the learning
process.

Capella MBA6018 unit 6 assignment latest 2016
july

Case
Analysis and Report

Resources

To
complete this assessment, use the Campus Crime Data Excel spreadsheet, located
in Resources. This file contains two data sheets:

1.
The Campus Crime Data for Minnesota (2009–2011) page, which
provides actual data generated by the U.S. Department of Education’s Campus
Safety and Security Data Analysis Cutting Tool.

2.
The Campus Crime Data Codebook, which explains the labels used in
the Campus Crime Data sheet.

Practical
Application Scenario

As
a result of recent campus safety concerns at Capella University, you have been
engaged by campus security team leaders to gather and analyze data about
on-campus crime rates in schools in the state of Minnesota. Crime data from 181
Minnesota campuses has been compiled in the Campus Crime Data file. Write a
management report for campus security team leaders, analyzing and evaluating
campus crime data for Minnesota. Include your findings and recommendations for
your clients. In your report, be sure to examine the following:

1.
What crimes were most commonly committed on Minnesota campuses
between 2009 and 2011? Based on the data, would you say the crime rates
decreased or increased from 2009 to 2011?

2.
The campus security leaders believe that the three-year total
crime rate in public institutions is higher than that in private institutions.
They have asked you to test that hypothesis. Conduct the test and describe your
results. To start, you will:

1.
Formulate the hypotheses statement.

2.
Determine the three-year total crime rate per institution,
separately, for private and public institutions.

3.
Use the appropriate statistical approach to conduct and test the
hypotheses for difference in crime rates.

3.
Your clients would also like you to develop a 95 percent
confidence interval for the difference in three-year total campus crime rates
between public and private institutions in Minnesota. Report your results.

4.
What, if any, ethical issues should concern you in conducting your
research?

Complete
your report in a Word document (submitted as a .docx file), including relevant
tables and graphics you need to support your findings. Place your tables and
graphics within the text and be sure to clearly title them. Your tables and
graphics must be legible and suitable for inclusion in a management report.

Before
you submit your assignment to your instructor for grading, submit a final
version of your paper to Turnitin.

Submit
your report to the assignments area for grading. Please note that assignments
must be submitted to the assignments area for grading. Work e-mailed or
otherwise presented cannot be graded in accordance with Capella Grading
Standards. Refer to the scoring guide to ensure that you meet the grading
criteria for this assessment.

Note:Your
instructor may also use the Writing Feedback Tool to provide feedback on your
writing. In the tool, click the linked resources for helpful writing
information.

Capella
MBA6018 unit 1 discussion latest 2016 july

Deriving and Presenting Descriptive Statistics

Imagine
that you are a real estate agent in Florida and you are working with a retired
couple from out of state. The couple is considering purchasing a retirement
home in Boca Raton. In order to make informed decisions about this potential
purchase, they first need to understand the Boca Raton real estate market.

For
this discussion, identify what you consider to be the three most significant or
descriptive home parameters (that is, price mean, price mode, home size mean,
home size mode, and so on) to give your clients an understanding of the Boca
market, and justify your selection. Draw on the results that you generated in
this unit’s assignment, using the Florida Pool Data file to help support your
perspective if you wish.

Response Guidelines

Now
imagine you are a member of that retired couple planning a move to Florida.
Respond to the initial posts of at least two peers, confirming or critiquing
the effectiveness of the measures they chose. Note why you, as a potential
buyer, agree or disagree with your peer’s evaluation of the Boca Raton housing
market. Remember, the goal is to select measures that accurately depict the
housing market and empower the clients to make informed decisions.

Selecting Appropriate Techniques

The human resources (HR) manager for Gorman Industries, LLC wants
to give a short survey to a sample of recent hires (defined as people who have
been with the company for less than one year). This sample will include several
thousand individuals. The HR manager wants to be able to develop a confidence
interval for the proportion of new hires that are happy with the company.

To get the sample, he has two plans:

• Plan 1: Stand
  at the door as people are entering and leaving a quarterly employee communications
  meeting. Whenever he sees someone with a red badge, which indicates less
  than one year with the company, he will stop that person and give him or
  her a packet with the survey and instructions.
• Plan 2: E-mail
  new employees with the packet attached and request they complete it and
  e-mail it back within three days.

What planned approach would you use and why? Base your decision on
statistical fact, potential cost, and HR management time to evaluate the
results. You can assume that a reasonable estimate for the proportion of new
hires that are happy with the company is 0.8.

Response Guidelines

Provide substantial feedback to at least two peers from the
perspective of the human resources manager.

Hypothesis Testing Assumptions

For its validity, all hypothesis testing depends heavily on the
assumption that the sample was drawn using probability sampling techniques. For
this discussion, answer the following:

• Why is it
  important that a sample be random?
• What can you do
  if you cannot use a probability sampling technique? (For example, suppose
  there is no good sampling frame available for the population of interest.)
• Provide an
  example of a population and explain how you would collect a random sample
  from that population.

Response Guidelines

Respond to the posts of at least two peers by sharing:

• Insight as to
  why probability sampling techniques are important.
• Your evaluation
  of your peer’s suggestions for alternatives to probability sampling.
• Suggestions for
  how to collect a random sample from the identified population.

Interactions

After
running a one-way ANOVA F-test, you find that at least two of the three means
differ. What should you do next and why? Post your response, providing an
example to illustrate your explanation.

Response Guidelines

Provide
substantive replies to the posts of at least two of your peers. For example,
you could ask clarifying questions to help your peers delve deeper into the
issue and provide illustrative examples.

The Mixed Methods Approach

Through your work in this unit, you have come to understand just
how different quantitative and qualitative decision-making techniques are.
Perhaps that is why a mixed methods decision-making technique could be
characterized as drawing from the best of both worlds. For this discussion,
post a reflection on how a mixed methods decision-making technique fits this
description, providing examples from your professional experience that could
have benefited—or did benefit—from a mixed methods approach. Remember to cite
and source your posts, if necessary.

Response Guidelines

Respond substantively to the posts of at least two peers. For each
post, provide additional support for the use of focus