MGMTW3IP
.docx
keyboard_arrow_up
School
Colorado Technical University *
*We aren’t endorsed by this school
Course
601
Subject
Business
Date
Feb 20, 2024
Type
docx
Pages
5
Uploaded by mistydspain
MGMT601W3IP
1
MGMT601-Unit 3 Individual Project
Misty D’Spain
Colorado Technical University
MGMT601W3IP
2
Use Common Statistical Tests to Draw Conclusions from Data
This project will explore the application of the chi-square distribution tool to support our decision to evaluate whether to broaden our horizon on market expansion or maintain our current situation with our sporting goods client. We detect that we do not have adequate data for a chi-square analysis, we will validate the initial steps of a nonparametric test, centering on qualitative aspects. Understanding Chi-Square and Hypothesis Testing
The chi-square distribution is a statistical tool used for hypothesis testing in nonparametric settings, which means it does not rely on specific assumptions about the data’s distribution. Instead, it examines the relationship between two categorical variables to determine if they are independent or if they are independent or if there is a significant association between them. The chi-square test helps make informed decisions by assessing the relevance and significance of observed data. The data used in calculating a chi-square statistic must be random, raw, mutually exclusive, drawn from independent variables, and drawn from a large enough sample (Hayes, 2021).
The Big D Scenario
In this study, working with the “Big D” scenario, considering two proposed product lines in the outdoor sporting goods market. Assuming the same demographics that are utilized for each product, meaning that we have data on the same group of potential customers.
Initial Steps of a Nonparametric Test
1.
Null and Alternative Hypothesis:
The first step in applying the chi-square test is formulating null (H0) and alternative (H1) hypotheses. In the scenario, the null hypothesis could be that there is no significant difference in customer preferences between the two proposed product lines, meaning they are equally likely to succeed in the market. The alternative hypothesis would be that there is a significant difference, suggesting that one product line is more likely to be successful than the other.
MGMT601W3IP
3
Null Hypothesis (H0): There is no significant difference in customer preferences between the two proposed product lines.
Alternative Hypothesis (H1): There are significant differences in customer preferences between the two proposed product lines.
1.
Data Collection and Analysis:
To initiate the chi-square process, we would need to collect data related to customer preferences for the two product lines. This data could include surveys, focus groups, or market research.
We would then organize this data into a contingency table, which would allow us to compare the observed and expected frequencies of the preferences for each product line.
(2) Data Collection and Analysis:
To initiate the chi-square process, we would need to collect data related to customer
preferences for the two product lines. This data could include surveys, focus groups, or
market research. We would then organize this data into a contingency table, allowing us to
compare the observed and expected frequencies of the preferences for each product line.
(3) Chi-Square Statistic and P-value:
After organizing the data, we calculate the chi-square statistic and the associated p-value. The chi-square statistic quantifies the difference between the observed and expected frequencies, the p-
value indicates the probability of observing such a difference by chance. The chi-square statistic compares the size of any discrepancies between the expected results and the actual results, given the size of the sample and the number of variables in the relationship (Hayes, 2021),
Implications for the Board of Directors and Decision-Making:
(1)
Hypothesis Testing Outcome:
The chi-square test will provide valuable insights into whether there is a statistically significant difference in customer preferences between the two proposed product lines. If
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
I just need the first 3 please (:
arrow_forward
1
arrow_forward
Describe and explain what CVP analysis is. Provide examples of how managers may use this tool for sensitivity analysis.
arrow_forward
Identify the categories of variables used by Mattel to segment the market for Max Steel action figures. Can you suggest additional variables that Mattel might use in this market?
arrow_forward
Hide Assignment Information
Instructions
Exercise #5
For this week exercise, we need to try a few logit models (see this link for more information: LOGIT REGRESSION)
If you have chosen to work with Excel, please run above three models and complete the following tables.
Model 1: Run a regression model and use being a member of network and find out its impact on hospital cost? (Model 1) Model 2: For the 2nd model run a regression model and use being a member of network and find out its impact on hospital cost and hospital revenue? (Model 2) Model 3: For the 3rd model run a regression model and use being a member of network and find out its impact on ratio-Medicare-discharge and ratio-Medicaid-discharge.
Based on your finding please recommend 3 policies and discuss the impact of being on a network on hospital cost, hospital revenue and out its impact on ratio-Medicare-discharge and ratio-Medicaid-discharge. Do you recommend keeping membership for a hospital? Why or why not?
arrow_forward
ABC is an online-to-offline platform that sells e-commerce products to offline customers through a network of agents. ABC gives a commission to agents for each sale made. ABC has 4 main product categories: electronics, fashion, supermarket, and others. Please refer to the exhibits for data sets pertaining to the questions below. Today is May 16th.
Q : 1. Today is May 16th. We have got the interim result of the sales figures in the first half of May. Typically, the first half of the month constitutes of 40% of sales. Using this assumption, will we reach our May target? What % over the target will we over/under-deliver?answer : over/deliver by ... % of target
Using that assumption, which category (or categories) will not reach the targeted sales figures in May?answer : ............
arrow_forward
I just need the last two please (:
arrow_forward
Help! I got it wrong again.
arrow_forward
The table below shows the sales figures for a brand of shoe over the last 12 months.
Months
Sales
January
69
February
75
March
86
April
92
May
95
June
100
July
108
August
115
September
125
October
131
November
140
December
150
Using the following, forecast the sales for the months up to January the following year:-
1. A simple three-month moving average.
2. A three-period weighted moving average using weights of 1, 2, and 3. Assign the highest weight to the most recent data.
3. Exponential Smoothing when α= .6 and the forecast for March is 350.
4. Determine which of the three forecasting techniques is the most accurate using MAD.
arrow_forward
What are the advantages and disadvantages of aggregating demand from a forecasting view? Are there other things that should be considered when going from multiple DCs to a DC?
arrow_forward
Lenovo uses the ZX-81 chip in some of its laptopcomputers. The prices for the chip during the past 12 monthswere as follows:
a) Use a 2-month moving average on all the data and plot theaverages and the prices.b) Use a 3-month moving average and add the 3-month plot tothe graph created in part (a).c) Which is better (using the mean absolute deviation): the2-month average or the 3-month average?d) Compute the forecasts for each month using exponentialsmoothing, with an initial forecast for January of $1.80. Use a= .1, then a = .3, and finally a = .5. Using MAD, which ais the best?
arrow_forward
What kind of prediction model will be more suitable for an enterprise that introduced a new product?
arrow_forward
In the table below ratings data on x = the quality of the speed of execution and y = overall satisfaction with electronic trades provided the
estimated regression equation ŷ = 0.3402 +0.8922x.
Brokerage
Speed Satisfaction
Scottrade, Inc.
3.5
3.4
Charles Schwab
3.0
3.1
Fidelity Brokerage Services
3.3
3.2
TD Ameritrade
3.6
3.5
E*Trade Financial
3.4
3.7
Vanguard Brokerage Services
3.8
3.6
USAA Brokerage Services
3.3
2.9
Thinkorswim
3.1
3.6
Wells Fargo Investments
2.4
2.4
Interactive Brokers
2.6
2.2
Zecco.com
2.7
3.1
At the 0.05 level of significance, test whether speed of execution and overall satisfaction are related. Show the ANOVA table. What is your
conclusion?
Source
Sum of Squares
Degrees
Mean Square
F
(to 2 decimals)
of Variation
(to 4 decimals)
of Freedom
(to 4 decimals)
Regression
Error
Total
P-value is - Select your answer -
We
Select your answer - V reject Ho : B1 = 0, we conclude that speed of execution and overall satisfaction
Select your answer - V related.
arrow_forward
Answer the following questions.
1. What is the current economic climate?
2. What should be our forecast accuracy target if there is a high degree
of volatility in customer orders and long lead times?
3. We have a new chief sales officer who is proposing that we should
forecast in dollars, not in units/cases. I have never heard of anyone
forecasting in dollars. It is true that dollarized forecasts can help Sales
in knowing precisely what sales target they should be hitting. But, is it
the best practice?
arrow_forward
Corporate triple-A bond interest rates for 12 consecutive months follow.
9.6
9.4
9.5
9.7
9.9
9.8
9.8
10.6
10.0
9.8
9.6
9.6
(b) Develop three-month and four-month moving averages for this time series. (Round your answers to two decimal places.)
Month
Time SeriesValue
3-Month MovingAverage Forecast
4-Month MovingAverage Forecast
1
9.6
2
9.4
3
9.5
4
9.7
5
9.9
6
9.8
7
9.8
8
10.6
9
10.0
10
9.8
11
9.6
12
9.6
(c) Using the more accurate forecast, what is the moving average forecast for the next month? (Round your answer to two decimal places.)
arrow_forward
Develop a clear research objective for the business problem described in the extract. (+-400 words)
arrow_forward
1. The table below shows the sales figure for a brand of shoe over the last 12 months.
MONTHS
SALES
January
69
February
75
March
86
April
92
May
95
June
100
July
108
August
115
September
125
October
131
November
140
December
150
Using the following, forecast the sales for the months up to January the following year:-
1. A simple three month moving average.ii. A three period weighted moving average using weights of 1, 2 and 3. Assign the highest weight to the most recent data.iii. Exponential Smoothing when a= .6 and the forecast for March is 350.
arrow_forward
I posted this question and it's been 18 hours that it still hasn't been answered. I only need the last two questions please (:
arrow_forward
Note:-
Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
Answer completely.
You will get up vote for sure.
arrow_forward
My App is a small but growing start-up that sees demand for several of its apps increasing quickly. The table below shows the last six
months of downloads. Use a forecast for the first month of 220,000, an initial trend forecast of 35,000, and smoothing parameters of
015 for both demand smoothing and trend smoothing
Month (t) Monthly Application Downloads Forecast for Next Month
Trend
220,000.00
35,000.00
200,000
2
250, 100
334,000
380,000
440,000
500,000
(Round your answers to 2 decimal places.)
Complete the table above, filling in the "Forecast for next month" and "Trend" columns, using double
a.
exponential smoothing
(Round your answers to 2 decimal places.)
Month 7's forecast is
b.
arrow_forward
Sales of a particular product (in the thousands of dollars) for the year of 2015 through 2018 have been $48,000, $64,000, $67,000 and $83,000 respectively. (a) What sales would you predict for 2019, using a simple four year moving average? (b) What sales would you predict for 2019, using a weighted moving average with weights of 0.50 for the immediate preceding year 0.3, 0.15, and 0.05 for the three years before that?
arrow_forward
Below is a table containing data on product demand for the most recent five months along with the forecasts that had been made for those 5 previous months. Use the 3-period weighted moving average method to forecast the number of sales to expect next month. Use the following weights: 0.4 for the most recent, 0.3 for the 2nd most recent, and 0.3 for the 3rd most recent.
Month
Demand
Forecast
1
308
337
2
388
341.4
3
344
368
4
400
342.8
5
341
378.4
arrow_forward
Problem #2 A & B please
Problem #3 A please
arrow_forward
Quantitative Methods II - Question 3
Please assist with i, ii & iii
arrow_forward
Q4B. What potential limitations or weaknesses are associated with using the Box –Jenkins Methodology for time series modelling?Q4C. Explain how the residuals of an ARMA model can be used to diagnose potentialmodel mis-specification issues? If any, how can these misspecification issues, beaddressed?
arrow_forward
This a 4 part question that am confused about. Please show the work by hand not excel. 4-1 Sales of a particular product (in the thousands of dollars) for the years 2015 through 2018 have been $48,000, $64,000, $67,000 and $83,000 respectively. (a)What sales would you predict for 2019, using simple four-year moving avaerage? (b) What sales would you predict for 2019, using a weighted moving average with weights of 0.50 for the immediate preceding year and 0.3, 0.15, and 0.05 for the three years before that? (I am able to calculate and know the answer for (a) $65,000 and (b) $73,000. What I don't understand is the following : 4-2 Using exponential smoothing with a weight of 0.6 on actual values: (a) If sales are $45,000 and $50,000 for 2017 and 2018, what would you forecast for 2019 ? (The first forecast is equal to the value of the preceding year.) (b) Given this forecast and actual 2019 sales of $53,000, what would you then forecast for 2020? 4-3 In Problem 4-1, taking…
arrow_forward
I just need the last one please (:
arrow_forward
Below is a table containing data on product demand for the most recent five months along with the forecasts that had been made for those 5 previous months. Use the 3-period simple moving average method to forecast the number of sales to expect next month.
Month
Demand
Forecast
1
308
341
2
388
343.3
3
344
364.7
4
400
346.7
5
341
377.3
arrow_forward
A Use a simple moving average model. Experiment with the models using five weeks and three weeks past data.
3 week MA
Week ATL BOS CHI DAL LA TOTAL
1
2
3
4
5
6
7
8
9
10
11
12
13
5 week MA
Week ATL BOS CHI DAL LA TOTAL
1
2
3
4
5
6
7
8
9
10
11
12
13
B evaluate the forecast that would have been made over the 13 weeks using overall mean absolutely deviation, mean absolute percent error, and tracking signal as criteria.
arrow_forward
The purpose of the Maricopa Association of Governments (MAG) is to achieve which of the following?
It is a charter government association for the county.
It is an organization that receives state funds for county projects.
It is a group that meets to collaborate on project ideas.
It is the largest Council of Government (COG) in Arizona and is a regional planning agency for funds received from the federal government.
arrow_forward
pls help
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
Related Questions
- Identify the categories of variables used by Mattel to segment the market for Max Steel action figures. Can you suggest additional variables that Mattel might use in this market?arrow_forwardHide Assignment Information Instructions Exercise #5 For this week exercise, we need to try a few logit models (see this link for more information: LOGIT REGRESSION) If you have chosen to work with Excel, please run above three models and complete the following tables. Model 1: Run a regression model and use being a member of network and find out its impact on hospital cost? (Model 1) Model 2: For the 2nd model run a regression model and use being a member of network and find out its impact on hospital cost and hospital revenue? (Model 2) Model 3: For the 3rd model run a regression model and use being a member of network and find out its impact on ratio-Medicare-discharge and ratio-Medicaid-discharge. Based on your finding please recommend 3 policies and discuss the impact of being on a network on hospital cost, hospital revenue and out its impact on ratio-Medicare-discharge and ratio-Medicaid-discharge. Do you recommend keeping membership for a hospital? Why or why not?arrow_forwardABC is an online-to-offline platform that sells e-commerce products to offline customers through a network of agents. ABC gives a commission to agents for each sale made. ABC has 4 main product categories: electronics, fashion, supermarket, and others. Please refer to the exhibits for data sets pertaining to the questions below. Today is May 16th. Q : 1. Today is May 16th. We have got the interim result of the sales figures in the first half of May. Typically, the first half of the month constitutes of 40% of sales. Using this assumption, will we reach our May target? What % over the target will we over/under-deliver?answer : over/deliver by ... % of target Using that assumption, which category (or categories) will not reach the targeted sales figures in May?answer : ............arrow_forward
- I just need the last two please (:arrow_forwardHelp! I got it wrong again.arrow_forwardThe table below shows the sales figures for a brand of shoe over the last 12 months. Months Sales January 69 February 75 March 86 April 92 May 95 June 100 July 108 August 115 September 125 October 131 November 140 December 150 Using the following, forecast the sales for the months up to January the following year:- 1. A simple three-month moving average. 2. A three-period weighted moving average using weights of 1, 2, and 3. Assign the highest weight to the most recent data. 3. Exponential Smoothing when α= .6 and the forecast for March is 350. 4. Determine which of the three forecasting techniques is the most accurate using MAD.arrow_forward
- What are the advantages and disadvantages of aggregating demand from a forecasting view? Are there other things that should be considered when going from multiple DCs to a DC?arrow_forwardLenovo uses the ZX-81 chip in some of its laptopcomputers. The prices for the chip during the past 12 monthswere as follows: a) Use a 2-month moving average on all the data and plot theaverages and the prices.b) Use a 3-month moving average and add the 3-month plot tothe graph created in part (a).c) Which is better (using the mean absolute deviation): the2-month average or the 3-month average?d) Compute the forecasts for each month using exponentialsmoothing, with an initial forecast for January of $1.80. Use a= .1, then a = .3, and finally a = .5. Using MAD, which ais the best?arrow_forwardWhat kind of prediction model will be more suitable for an enterprise that introduced a new product?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios