Details of this Paper

BUS/308 Entire Course (Statistics for Managers)

Description

solution


Question

BUS/308 Entire Course;Product Description;Week 1;DQ 1;Data Scales.;A marketing agency is interested in the buying habits of those who shop online versus those who shop in person. In your discussion post, address each of the following and explain your reasoning as to why you picked the specific scale;a. A database is created and shoppers are classified as online or in-person shoppers. Such classifications represent data of which scale? Explain your reasoning.;b. Online and in-person shoppers are to be compared on their relative incomes. Income data represent data of which scale? Explain your reasoning.;c. If shoppers are also ranked from the most to the least frequent shoppers, those rankings represent data of which scale? Explain your reasoning.;d. Shoppers are asked to complete a customer satisfaction survey. In response to each question on the survey, the shoppers circle one of five answers: strongly agree, agree, neutral, disagree, or strongly disagree. Their responses are data of which scale? Explain your reasoning.;e. What measure(s) of central tendency will be most informative for each of the above data? Justify why each measure is most informative.;f. What would be more critical for the marketing agency to utilize, descriptive or inferential statistics? Why?;DQ 2;Probability.;The manager of a sandwich shop gathers data on what people spend on lunch on a particular day of the week.;The results are $4.20, $4.22, $2.35, $4.32, $5.25, $6.48, $6.78, $8.59, $6.95, $5.52, $6.83, $7.35, $4.36, $9.39, $6.42.;To the degree that this represents the population of all those who eat lunch at sandwich shops, what percentage of customers spend;a. less than $4.34?;b. between $3.50 and $4.80?;c. less than $2.35?;Imagine that you are the manager of a sandwich shop. Based on your calculations, what do you think is the best pricing point for your shop? What would you do to increase sales at the sandwich shop?;For additional information on calculating probability refer to the Week One Recommended Resources.;Problem Set Week One.;Assignment Instructions;Complete the problems below and submit your work in one Word document. Be sure to show all of your work and clearly label all calculations. Calculations completed in Excel must be copied and pasted into a single Word document. No Excel documents will be graded.;For additional assistance with these calculations reference the Recommended Materials for Week One.;TIP: For help copying and pasting information from Excel to Word go to http://office.microsoft.com/en-us/word-help/copy-excel-data-or-charts-to-word-HP010198874.aspx or watch the ?Excel Tips - Tip#48: Copy from Excel to Word? video found in Week One Recommended Resources.;Problem 1;The performances of a group of interns are evaluated by their supervisors at the end of their internships.;Their scores are: 55, 47, 62, 27, 50, 49, 66, 53, 50, 44, 63, 59.;Complete the calculations below using this data. Show all of your work and clearly label each of your calculations.;a. the mean;b. the median;c. the range;d. the standard deviation;e. the variance;Problem 2;The Anxiety General Stress Test (ANGST) has been designed to gauge the level of psychological stress management trainees experience when they are under pressure.;For a random sample of trainees the scores are as follows: 47, 49, 53, 53, 54, 58, 61, 64, 75, 81.;Complete the calculations below using this data. Show all of your work and clearly label each of your calculations.;a. What is the z score equivalent of?;b. What is the probability that someone selected at random will score 81 or lower?;c. What percentage of all trainees will score between 60 and 75?;Copy and paste your calculations for the three problems from Excel to Word and submit one Word document with your clearly labeled calculations and interpretations.;ASHFORD BUS 308 Week 1 Quiz;Week 2;DQ 1;t-Tests.;Imagine a shift manager at a manufacturing plant is gathering data on the number of units workers assemble during two different shifts over 10 different days. If the number of units assembled by each shift varies greatly from day to day, what impact will that have on the likelihood of a significant difference between the two shifts? Explain and support your response.;DQ 2;ANOVA Testing.;The manager of an agency providing temporary employees to city offices is analyzing the number of days temporary hires typically work in various types of industries.;The data are as follows;Legal clerical: 2, 1, 4, 4, 2, 5, 6;Accounting firms: 3, 6, 4, 5, 5, 7, 8;Insurance: 5, 4, 7, 9, 9, 8, 11;Using the data above, answer the following questions;a. Are there significant differences in the length of time temporary employee?s work in the different industries?;b. How much of the differences can be explained by the industry?;c. Which groups are significantly different from others?;d. Why would a manager be focused on measuring the number of days that a temporary works each week?;ASHFORD BUS 308 Week 2 Quiz;Problem Set Week Two.;Assignment Instructions;Complete the problems below and submit your work in one Word document. Be sure to show all of your work and clearly label all calculations. Calculations completed in Excel must be copied and pasted into a single Word document. No Excel documents will be graded.;TIP: For help copying and pasting information from Excel to Word go to http://office.microsoft.com/en-us/word-help/copy-excel-data-or-charts-to-word-HP010198874.aspx or watch the ?Excel Tips - Tip#48: Copy from Excel to Word? found in Week One Recommended Resources.;Problem One;Suppose that an automotive parts and accessories chain is experimenting with a new sales promotion. Two similar stores are selected for the experiment. For Store 1, nothing changes. This store constitutes the control group. For Store 2, the treatment group, the promotion is implemented.;Sales in hundreds of dollars over a five-day period are as follows;Control: 6, 6, 7, 10, 12, 9, 6, 5, 5, 7;Treatment: 2, 5, 2, 4, 7, 1, 2, 3, 4, 5;The expectation that sales will be higher in the treatment group makes this a one-tailed test, the alternate hypothesis is m1 < m2. Use Excel to determine whether differences between the two groups are statistically significant.;Show all of your work and clearly label each of your calculations. Share your calculations and your interpretations of your findings in your Word document.;Problem Two;Suppose that a home builder is approached by a customer who wants to move in as soon as possible. The customer chooses three home designs that she likes and asks the home builder which one could be completed the fastest. To compare the three designs on speed of completion, the builder randomly selects 10 homes that he built in the past based on each of the three designs.;Use the Excel Analysis ToolPak to run an ANOVA test in order to determine which design would be best for the customer. Show all of your work and clearly label each of your calculations. Make sure to also clearly describe the respective data and your conclusions.;The data for the number of days to build each home are as follows;Design A: 15, 17, 19, 21, 23, 25, 27, 29, 31, 33;Design B: 29, 34, 39, 44, 49, 54, 59, 64, 69, 74;Design C: 22, 24, 25, 27, 28, 28, 29, 31, 33, 34;For more information on conducting an ANOVA test in Excel reference the Week Two Recommended Resources.;Problem Three;An insurance company is reviewing its current policy rates. When originally setting the rates they believed that the average claim amount was $1,800. Now there are concerns that if the true mean is actually higher than this they could potentially lose a lot of money. They randomly select 40 claims, and calculate a sample mean of $1,950. Assuming that the standard deviation of claims is $500, and set significance, test to see if the insurance company should be concerned.;Show all of your work and clearly label each of your calculations. Share your calculations from Excel and your interpretations of your findings in your Word document.;Copy and paste your calculations for the three problems from Excel to Word and submit one Word document with your clearly labeled calculations and interpretations;Week 3;DQ 1;Interval Data.;A courier service in a large city tracks the number of deliveries they are asked to make by 10 clients both before and after offering a progressive discount for repeat business. Their goal is to assess the effects of the discount.;a. What is the most appropriate statistical test in this situation? Why?;b. Are there significant differences in the number of deliveries?;c. If the goal is to promote repeat business, should the discount be continued?;DQ 2;Correlation.;An employment agency gathers the following data on its clients;a) Age;b) Gender;c) Educational level (no high school, high school, associate?s, bachelor?s, master?s);d) Years of past experience;e) Whether or not they have been successfully placed in employment by the agency;Additionally, the following data is gathered for those who have been successfully placed;a) Starting salary;b) Current salary;c) Tenure in months;Based on the information above answer the following questions;a. Which type of correlation procedure would be most appropriate to gauge the relationship between each pair of variables?;b. Do you expect each pair of variables to be significantly correlated or not? Why?;c. For the variables you expect to be significantly correlated, what do you expect the direction of the relationship to be? Why?;Week 3;Evaluation of Correlations.;Assignment Instructions;Data are gathered regarding the length of tenure top executives have at a major corporation and whether those executives have been divorced. The Human Resources department is evaluating this data to drive decision-making in regard to their hiring process. The data for eight executives is as follows;In a three to five page paper, excluding title page and reference page(s), answer the following questions to analyze the data. Include clearly labeled calculations, if applicable. Calculations conducted in Excel must be copied and pasted into the Word document. This paper should be formatted according to APA guidelines outlined in the Ashford Writing Center.;a. What?s the most appropriate procedure for evaluating the relationship between tenure and divorce?;b. What is the correlation and how can it be interpreted in terms of magnitude, direction and practical importance?;c. How much of whether executives have been divorced can be accounted for by their length of tenure with the organization? How much of tenure can be explained by whether there has been a divorce?;d. Make a logical argument for why lengthy tenure may be causing divorce.;e. Make another logical argument for why divorce may be causing lengthy tenure.;Make sure to support your arguments with at least two articles from the Ashford Library or other scholarly sources. All calculations conducted in Excel must be copied and pasted into the Word document before submission. Be sure to clearly label all calculations.;Week 4;DQ 1;Simple Regression Analysis.;Use the data in the chart to answer the questions below. The data indicates the number of ?sick days? appliance installers take during a three month period, and the number of complaints filed by customers during the same interval. Use the Analysis Toolpak in Excel to perform this simple regression and answer the questions.;a. Is the correlation between number of sick days and number of customer complaints statistically significant?;b. What is the best prediction for the number of complaints that will be registered for an installer who takes five sick days during the period?;Use Excel to help you answer the questions in the forum but do not attach your Excel document to the discussion post.;DQ 2;Multiple Regression Analysis.;Develop a multiple linear regression equation that describes the relationship between tenure and the other variables in the chart above. Use the Analysis Toolpak located in Excel to perform this multiple regression.;Do these two variables explain a reasonable amount of the variation in the dependent variable?;Estimate the tenure of someone that could have $5.8($k) and 15 years of job satisfaction. Make sure to state your multiple regression equation in your example. What are some of things that you can estimate from the model? How effective is evaluating the R-squared of the model? What is the relationship between the independent and dependent variables?;Use Excel to help you answer the questions in the forum but do not attach your Excel document to the discussion post.;Guided Response: Review several of your classmates? postings. Respond to at least two classmates by commenting on how this information might be used to make business decisions.;Problem Set Week Four.;Complete the problems below and submit your work in one Word document. Be sure to show all of your work and clearly label all calculations. Calculations completed in Excel must be copied and pasted into a single Word document. No Excel documents will be graded.;TIP: For help copying and pasting information from Excel to Word go to http://office.microsoft.com/en-us/word-help/copy-excel-data-or-charts-to-word-HP010198874.aspx or watch the ?Excel Tips - Tip#48: Copy from Excel to Word? found in Week One Recommended Resources.;Problem One;The manager of a catering company is using the number of people in the party to predict the cost of the drinks that are required for the event. The following are the data for 12 recently catered events;Complete the calculations below using this data. Show all of your work and clearly label each of your calculations.;a. Provide a scatterplot;b. Calculate a linear regression;c. Calculate the residuals;d. Calculate the correlation between the two variables;e. Calculate the mean, median, and standard deviation of the number of people and cost of drinks;For additional assistance with these calculations reference the Recommended Materials for Week Four.;Problem Two;You are a real estate agent and you are trying to predict home prices for your clients that want to list their house for sale. You have a very small city without much data. You will need to use the data that you have available for the past year on homes that have been sold.;Complete the calculations below using this data. Show all of your work and clearly label each of your calculations.;Conduct a multiple regression analysis to predict home prices. In your analysis complete the following;a. Calculate the multiple regression analysis and report your data.;b. Determine the list price for your client?s home if it has three bedrooms, three bathrooms, and 1900 square footage. Provide your analysis and show all of your calculations.;For additional assistance with these calculations reference the Recommended Materials for Week Four.;Week 5;DQ 1;Confidence Intervals.;A hardware retailer has average sales of $64,235 with a standard deviation of $5,918 for a 12-month period. The mean monthly sales for all retailers in the chain are $59,844. Is this hardware retailer?s sales significantly different from all retailers in the chain at? Are they significantly different at? Calculate a.95 confidence interval for the data in problem.;Explain your findings and determine what question the confidence interval answers.;Guided Response: Review several of your classmates? postings. Respond to at least two classmates by commenting on whether or not you think changing the confidence intervals will result in a different outcome. Explain if you agree or not with the role of a confidence interval in the interpretation of the answer;DQ 2;Correlation and Confidence Intervals.;A car dealer is using the number of years customers have owned their vehicles to predict how long it will be before they elect to replace them. The correlation between the two is (the longer they have owned their present vehicles, the more quickly they are expected to replace them). The other relevant data are as follows for 32 customers;Based on the information above, answer the following questions;a. How long is the time to expected replacement for a customer who has owned a vehicle 6.5 years?;b. Calculate.95 and.99 confidence intervals and explain your results.;c. How will a larger standard deviation in the criteri

 

Paper#81083 | Written in 18-Jul-2015

Price : $37
SiteLock