Assignment 1 MBA 502
.pdf
keyboard_arrow_up
School
Illinois State University *
*We aren’t endorsed by this school
Course
502
Subject
Business
Date
Feb 20, 2024
Type
Pages
2
Uploaded by CountFangElk19
Aidan Hickey
Professor Dave Morton
MBA 502 - Analytical Tools for Management Decisions
January 13th, 2024
Assignment 1
Memo:
Colvard Office Products, an office furniture supplier and producer, currently utilizes a
test at the end of their one-week training program that is aimed at assessing how much each
salesperson learned over the course of their training. To determine if it would be reasonable to
eliminate portions of this four-hour final test to minimize costs, a statistical analysis needed to be
conducted. The objective of this statistical analysis was to run a variety of correlation tests and
regression analysis on each of the three subscores of the sales training test as well as the total of
these subscores. By conducting this analysis, it can be calculated which subscore, alone or in
total, provides the best predictor of performance among Colvard Office Products salespersons at
the end of the first year. After analyzing each subscore as well as the total score in relation to
predictability of sales performance, it was determined that the total score was the most accurate
indicator of sales performance. While the total score was deemed to be the best indicator of sales
performance, out of the three subscores, SubScore3 was determined to be the best predictor of
sales performance. SubScore3, according to the correlation and regression analysis, is only a
slightly less effective indicator of sales performance than the total score. Upon conducting the
analysis and the potential benefits gained from implementing a shortening of the test, it can be
reasonably proposed that the four-hour final written test be shortened to cut costs. Because
SubScore3 provides a statistically similar prediction of sales performance when compared to
total score, it would be financially beneficial for Colvard Office Products to cut out SubScore1
and SubScore2 and keep SubScore3 for evaluating salespersons.
Analysis:
The first step in conducting this statistical analysis was to go through the data containing
the test results from the most recent 120 salespersons hired by Colvard Office Products. After
looking over the test scores and sales ratings concerning the 120 salespersons, a correlation table
was created. A correlation table shows how high or low a given variable is correlated with other
variables in a dataset. Upon creating the correlation table, it was found that the total score and
SubScore3 were correlated the most with sales rating. This meant that, by correlation, the total
score and SubScore3 data were the best predictors of sales rating among Colvard Office Products
salespersons. With the correlation data gathered, the next step was building graphs to visually
represent the correlation. To do this, scatter plot charts of the total score and each subscore were
created. These scatter plot charts also featured trendlines, as well as the linear equations for those
trendlines. When looking at the scatter plot charts for total score and SubScore, it is clear that
each set of data have highly positive correlations to sales rating. Following this set of statistical
analysis, it was crucial to determine if total score and SubScore3 were relevant variables relating
to sales rating. To better understand the relevancy of total score and SubScore as variables, a
regression analysis was conducted on each of these variables. Following the regression analysis,
it was determined that both total score and SubScore3 were relevant variables when compared to
sales rating. With this data, sales rating could be reasonably predicted using the regression
statistics of total score and SubScore3 compared to sales rating. With SubScore3, each one point
increase suggests a 1.208 point increase in sales rating. With total score, each one point increase
suggests a .420 point increase in sales rating. The correlation analysis combined with the
regression analysis indicates that total score and SubScore3 are reasonable indicators of sales
rating among Colvard Office Products employees.
When evaluating all the statistical analysis conducted over the course of this study, it is
reasonable to conclude that Colvard Office Products should shorten the final test. Since
SubScore3 has a similar correlation to total score when compared to sales rating, it would be
financially advantageous to shorten the test to just SubScore3. While total score is the best
indicator of sales rating according to the regression and correlation analysis, it would make much
more sense from a business perspective to shorten the test. By shortening the test to SubScore3,
Colvard Office Supplies would optimize the efficiency of the test while also still having a test
that provides a very reliable indication of sales performance among new employees. This test
shortening
could
have
detrimental
consequences,
however.
For
example,
by
taking
out
SubScore1 and SubScore2, the company runs the risk of having less data to evaluate the
readiness of their incoming employees. This could lead to difficulties among upper management
when determining how certain salespersons will perform in the real world. With these negative
potential consequences in mind, it is still reasonable for Colvard Office Products to shorten their
final test. Overall, the shortening of the final test provides the company a much less time
consuming and far more cost effective strategy for evaluating the potential success of their
salespeople.
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
15. A manager of a store wants it to be the sales leader in the region. In order to achieve this goal, the
manager must analyze data to determine whether objectives have been met, efficiencies achieved,
and goals obtained.
Which tool should this manager use for this assessment?
A:Key performance indicators (KPIs)
B:Revenue growth rate (RGR)
C:Customer lifetime value (CLV)
D:Customer acquisition cost (CAC)
arrow_forward
A marketing manager wants to know if the sales of the company will increase if he increases the advertising budget. Here, the manager would like to know the nature of the relationship that may be established between advertising and sales by testing the hypothesis: “If advertising is increased, then sales will also go up.”
question : Suggest research design for this study.
arrow_forward
QUESTION: MARKETING ANALYTICS
What kind of analytics do we need to make marketing decisions?What kind of data, how do we collect it, and what do we want to get from the data? What is the purpose of data analysis? Give examples
arrow_forward
Question 1: Sweet Cookies is planning to launch a new line of cookies, but it’s little unsure of the market reaction. The new line of cookies has a mixed chocolate-pineapple flavor and will be targeted at the premium end of the market. Assume that you are marketing researcher hired by the firm. Formulate the:
Management decision problem.
Marketing research problem and its components.
Research design.
arrow_forward
Q1
Your company recently launched a new "dry" shampoo. Although initial
sales were strong, they have steadily declined over the last year and a half.
You have decided to conduct further market research, but first, you have to
define the research problem. Prepare a short report that clearly and fully
defines the research problem for your product.
arrow_forward
Q3:
Suppose you work for a Logistics company as an HR Manager. The female employees in your company has been facing discrimination in terms of pay raise, field visits and promotions. In this regard, complaints are lodged by them to the HR department for fair treatment. Your CEO is concerned about this issue and he has asked you to conduct a research study to find out the causes of discriminatory practices at the workplace. You believe qualitative research to be the suitable type of research for this study. Plan a qualitative study to investigate discriminatory practices against women in your company and provide the following with proper rationale:
Research design
Research question (at least 1 main and 2 sub questions)
Three themes for your literature review
References (at least five relevant papers)
arrow_forward
What would be a good justification/rationale for choosing
Topic: The impact of working in the hotel industry during Covid-19
Research Question: How has covid-19 affected the day-to-day operations and productivity as it relates to face-to-face and remote working at the hotel, and the lives of the employees. What is life like during and post pandemic?
arrow_forward
Question 1
(i) What are the 5 components of the COSO framework?
A. Risk assessment, control environment, control activities, information and communication, monitoringB. Control environment, risk assessment, control activities, information and communication, monitoring.C. Control activities, monitoring, information and communication, control environment monitoringD. Control activities, control environment, risk assessment, monitoring, information and communication
(ii) An opinion which is given by the auditor when the financial statements give a true and fair view except for a particular matter, which the auditor explains is called:A. An adverse opinionB. An unmodified opinionC. A qualified opinionD. A disclaimer opinion
(iii) Which of the following is NOT a reason why linking reward to performance may not solve remuneration problems?A. Unsuitable measures of performance may be selected B. Many performance measures are based on the short term resultsC. Remuneration systems are normally…
arrow_forward
End-of-Chapter Application Case
Why is beer flavor important to Coors’ profitability?
What is the objective of the neural network used at Coors?
Why were the results of Coors’ neural network initially poor, and what was done to improve the results?
What benefits might Coors derive if this project is successful?
What modifications would you make to improve the results of beer flavor prediction?
arrow_forward
Topic: The study of customers’ behavior towards online shopping as opposed to in-store in the Caribbean.
What can be the Significance of Research, Research Question/s, and definition of key terms based on the topic above?In a qualitative method approach.
arrow_forward
Question 4.
What role does an operational concept definition play in planning a research project?
arrow_forward
Definition and Comparison Questions: For each question, provide an explanation of the marketing terms, compare and contrast them and provide examples of how they are used in marketing.
Q 1.2: Primary data and Secondary Data:
arrow_forward
QUESTION 37
Which is identified as the foundation for the marketing plan?
a. Target market segmentation
b. Value proposition development
c. Market research
d. Market plan development
Why are failure rates for new products debatable?
a. Failure rates are high
b. Failure rate has a defined inclusive definition
c. The market is always changing
d. Failure rate is not clearly defined
arrow_forward
The correct answer is: Marketing Information System
Question 8
Incorrect
Mark 0.00 out of 1.00
12. All the followings are true regarding the marketing process except:
a. Only those who work in the traditional marketing department are charged with performing marketing activities
b. Marketing is involved whenever individuals or organizations have a choice to make
C. Any individual inside of an organization who can potentially win or lose customers is in marketing
d. Any set of activities attempting to influence consumer choice is marketing
The correct answer is: Only those who work in the traditional marketing department are charged with performing marketing activities
arrow_forward
Analysis of Journal Article: Fergnani, A (2022) Corporate Foresight: A New Frontier for Strategy and Management, Academy of Management Perspectives, Vol.36, No.2 pp.820-844. It is essential that each concept is defined clearly, accurately, and with excellent detail. It may be useful to critique or supplement the work of the core author by referencing the work of other scholars.
Q1. Provide a brief definition of each of these concepts and explain why it is significant for corporate strategic management in 500 words. You might find it useful to supplement this with other scholars’ work on these concepts.
The article defines and explains the significance of the following key concepts in corporate strategic management:
VUCA environment,
Corporate Foresight,
Resource Based View of the Firm,
Dynamic Capabilities Framework,
Absorptive Capacity,
Environmental Dynamism,
Environmental Complexity.
Scenario Planning.
arrow_forward
Q-2. Explain, giving reasons and examples, which is more important in business studies, applied or basic research.
arrow_forward
what is sometimes referred to as the Wrong Pocket problem associated with public health funding.
question: Briefly define and describe the Wrong Pocket concept, using childhood vaccinations as a point of reference. How does program evaluation help to address the Wrong Pocket issue.
https://www.nj.com/politics/2015/03/poll_should_religious_exemptions_from_child_vaccin.html#incart_river
arrow_forward
Definition and Comparison Questions: For each question, provide an explanation of the marketing terms , compare and contrast them and provide examples of how they are used in marketing.
Q 1.3: Core Product Level and Augmented Product-Level of a Product
arrow_forward
Q3. Write thesis statements for the following three general subjects.
1 - Diminishing cultural values
2 - Social networking sites
3 - Brands
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
BUSN 11 Introduction to Business Student Edition
Business
ISBN:9781337407137
Author:Kelly
Publisher:Cengage Learning
Essentials of Business Communication (MindTap Cou...
Business
ISBN:9781337386494
Author:Mary Ellen Guffey, Dana Loewy
Publisher:Cengage Learning
Accounting Information Systems (14th Edition)
Business
ISBN:9780134474021
Author:Marshall B. Romney, Paul J. Steinbart
Publisher:PEARSON
International Business: Competing in the Global M...
Business
ISBN:9781259929441
Author:Charles W. L. Hill Dr, G. Tomas M. Hult
Publisher:McGraw-Hill Education
Related Questions
- 15. A manager of a store wants it to be the sales leader in the region. In order to achieve this goal, the manager must analyze data to determine whether objectives have been met, efficiencies achieved, and goals obtained. Which tool should this manager use for this assessment? A:Key performance indicators (KPIs) B:Revenue growth rate (RGR) C:Customer lifetime value (CLV) D:Customer acquisition cost (CAC)arrow_forwardA marketing manager wants to know if the sales of the company will increase if he increases the advertising budget. Here, the manager would like to know the nature of the relationship that may be established between advertising and sales by testing the hypothesis: “If advertising is increased, then sales will also go up.” question : Suggest research design for this study.arrow_forwardQUESTION: MARKETING ANALYTICS What kind of analytics do we need to make marketing decisions?What kind of data, how do we collect it, and what do we want to get from the data? What is the purpose of data analysis? Give examplesarrow_forward
- Question 1: Sweet Cookies is planning to launch a new line of cookies, but it’s little unsure of the market reaction. The new line of cookies has a mixed chocolate-pineapple flavor and will be targeted at the premium end of the market. Assume that you are marketing researcher hired by the firm. Formulate the: Management decision problem. Marketing research problem and its components. Research design.arrow_forwardQ1 Your company recently launched a new "dry" shampoo. Although initial sales were strong, they have steadily declined over the last year and a half. You have decided to conduct further market research, but first, you have to define the research problem. Prepare a short report that clearly and fully defines the research problem for your product.arrow_forwardQ3: Suppose you work for a Logistics company as an HR Manager. The female employees in your company has been facing discrimination in terms of pay raise, field visits and promotions. In this regard, complaints are lodged by them to the HR department for fair treatment. Your CEO is concerned about this issue and he has asked you to conduct a research study to find out the causes of discriminatory practices at the workplace. You believe qualitative research to be the suitable type of research for this study. Plan a qualitative study to investigate discriminatory practices against women in your company and provide the following with proper rationale: Research design Research question (at least 1 main and 2 sub questions) Three themes for your literature review References (at least five relevant papers)arrow_forward
- What would be a good justification/rationale for choosing Topic: The impact of working in the hotel industry during Covid-19 Research Question: How has covid-19 affected the day-to-day operations and productivity as it relates to face-to-face and remote working at the hotel, and the lives of the employees. What is life like during and post pandemic?arrow_forwardQuestion 1 (i) What are the 5 components of the COSO framework? A. Risk assessment, control environment, control activities, information and communication, monitoringB. Control environment, risk assessment, control activities, information and communication, monitoring.C. Control activities, monitoring, information and communication, control environment monitoringD. Control activities, control environment, risk assessment, monitoring, information and communication (ii) An opinion which is given by the auditor when the financial statements give a true and fair view except for a particular matter, which the auditor explains is called:A. An adverse opinionB. An unmodified opinionC. A qualified opinionD. A disclaimer opinion (iii) Which of the following is NOT a reason why linking reward to performance may not solve remuneration problems?A. Unsuitable measures of performance may be selected B. Many performance measures are based on the short term resultsC. Remuneration systems are normally…arrow_forwardEnd-of-Chapter Application Case Why is beer flavor important to Coors’ profitability? What is the objective of the neural network used at Coors? Why were the results of Coors’ neural network initially poor, and what was done to improve the results? What benefits might Coors derive if this project is successful? What modifications would you make to improve the results of beer flavor prediction?arrow_forward
- Topic: The study of customers’ behavior towards online shopping as opposed to in-store in the Caribbean. What can be the Significance of Research, Research Question/s, and definition of key terms based on the topic above?In a qualitative method approach.arrow_forwardQuestion 4. What role does an operational concept definition play in planning a research project?arrow_forwardDefinition and Comparison Questions: For each question, provide an explanation of the marketing terms, compare and contrast them and provide examples of how they are used in marketing. Q 1.2: Primary data and Secondary Data:arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- BUSN 11 Introduction to Business Student EditionBusinessISBN:9781337407137Author:KellyPublisher:Cengage LearningEssentials of Business Communication (MindTap Cou...BusinessISBN:9781337386494Author:Mary Ellen Guffey, Dana LoewyPublisher:Cengage LearningAccounting Information Systems (14th Edition)BusinessISBN:9780134474021Author:Marshall B. Romney, Paul J. SteinbartPublisher:PEARSON
- International Business: Competing in the Global M...BusinessISBN:9781259929441Author:Charles W. L. Hill Dr, G. Tomas M. HultPublisher:McGraw-Hill Education
BUSN 11 Introduction to Business Student Edition
Business
ISBN:9781337407137
Author:Kelly
Publisher:Cengage Learning
Essentials of Business Communication (MindTap Cou...
Business
ISBN:9781337386494
Author:Mary Ellen Guffey, Dana Loewy
Publisher:Cengage Learning
Accounting Information Systems (14th Edition)
Business
ISBN:9780134474021
Author:Marshall B. Romney, Paul J. Steinbart
Publisher:PEARSON
International Business: Competing in the Global M...
Business
ISBN:9781259929441
Author:Charles W. L. Hill Dr, G. Tomas M. Hult
Publisher:McGraw-Hill Education