part 2
.docx
keyboard_arrow_up
School
University of Tasmania *
*We aren’t endorsed by this school
Course
743
Subject
Business
Date
Jun 22, 2024
Type
docx
Pages
7
Uploaded by JusticeAntelopePerson683941
1
Table of content
Scatterplot of the data and regression analysis
The answer to
Q. a -----------------------------------------------------------
(3)
Seasonal Patterns
The answer to
Q. b. ----------------------------------------------------------
(4)
Business reporting best practices and steps will help business reports
stand out
The answer to
Q. c -------------------------------------------------------
(4 -
5)
Reference list ------------------------------------------------------------------------- (8)
TTEC605 Data analytics
2
Q.1). Scatterplot of the data and Regression analysis
As there is a clear upward trend in the data, but fluctuations deviate from a straight line, a
linear trend does not seem to fit these data well. The data would not adequately represent
the changes in the data over time if a linear trend were to be fitted to the data.
A linear trend is a straight line that is used to model a pattern in data over time. The slope
and y-intercept of the line are calculated using the least squares method.
Once we have the final plot, we can see that the graph does indeed exhibit a distinct linear
trend. The purchase of airline tickets has undoubtedly increased over the years. When it
comes to airline ticket sales in 2019, the month of November is when they reach their
highest level.
The customer value changes and manifests a behaviour during specific months and during
certain seasons. Total ticket sales have surpassed 3,000, just like in the months of June,
May, and November. While the number of customers rises annually in January, there are
fewer customers overall than in other months. i. e 2619.
TTEC605 Data analytics
3
Q.2)
Seasonal Patterns These sales data show that there is a seasonal pattern. Sales are typically higher in May,
June, July, October, and November and lower in January, February, March, August, and
September. The seasonal component can be used to forecast future values by first
separating it from the trend and residual components using a seasonal decomposition.
This method divides the data into three parts: the trend component, which captures the
long-term changes in the data; the seasonal component, which captures the regular
fluctuations in the data; and the residual component, which captures the random
fluctuations in the data that are not explained by the trend or seasonal components. Once
the seasonal component has been determined, it can be used to predict future values under
the presumption that the pattern will persist.
Q.3
TTEC605 Data analytics
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
Question 3
An organization uses a business intelligence system to predict products that tend to
be purchased together. This is an example of.
O A) Regression Analysis
B) Cluster Analysis
C) REM Analysis
D) Market Basket Analysis
arrow_forward
Q1.What is the difference between the types of data 1- categorical data, 2- numerical data, with an example of each type
arrow_forward
Divvy Bikes 2021 summer ridership has increased 30% from the ridership levels in 2020. Divvy's management attributes this to 2020 having fewer work places and recreation venues were open than in 2021.
This is an example of which type of data analytics?
Question 6 options:
a)
Descriptive
b)
Diagnostic
c)
Predictive
d)
Prescriptive
arrow_forward
Which test is best to test the hypothesis that multiple variances (2 or more) are equal?
Group of answer choices
1. t test
2. proportions test
3. Mood's median test
4. Levene's test
5. Analysis of Variance (ANOVA)
arrow_forward
Month
Actual Sales
Naive Forecast-
Absolute Value of
(# of Product X)
Sales
Errors
(# of Product X)
Jan/19
Feb/19
Mar/19
Apr/19
May/19
Jun/19
Jul/19
Aug/19
Sep/19
Oct/19
Nov/19
Dec/19
Jan/20
1,860
2,033
3,556
4,211
6,250
7,990
10,250
9,850
9,980
9,990
7,895
5,353
- Explain the calculation method for the Naive Forecast model.
the faln
arrow_forward
QUESTION 2:The manager of YTL Computers wants to develop next year’s quarterly forecasts of salesrevenue for its brand laptops. The sales are seasonal and the company believes that thefollowing most recent eight quarters of sales should be representative of next year’ssales:
Year
Quarter
Sales (millions of dollars)
1
1
9.2
1
2
5.4
1
3
4.3
1
4
14.1
2
1
10.3
2
2
6.4
2
3
5.4
2
4
16.0
Determine the forecast of next year’s quarterly sales revenue for this line of laptops.Show all your workings.
arrow_forward
Q5) Monthly sales for a six month period are as follows:
Month SalesJan 18,000Feb 22,000Mar 16,000Apr 18,000May 20,000June 24,000
Compute the sales forecast for July using the following approaches: (1) Four-month moving average; (2) Weighted three-month moving average using .50 for June, .30 for May and .20 for April;(3) Exponential smoothing with α (smoothing constant) equal to .40, assuming a February forecast of 18,000
arrow_forward
V.
Let's Explore / Let's Create
1. Discuss the other types of forecasting methods that financial analysts use to predict future
revenues.
2. Are there any several other factors that may need to be considered that affects the sales forecast?
RUBRIC
Criteria
Poor (3 Points)
Fair (7 Points)
Fair
Good (10 Points)
Good
Deer
arrow_forward
1. Give a specific example and scenario in Hospitality Industry that we can apply the
Data Analysis Cycle.
Identify the
Problem
Identify
Available Data
Sources
Identify if
Additional Data
Sources are
needed
Statistical
Analysis
Implementation
and
Development
Communicate
Results
Maintenance
arrow_forward
06
A
B
xfx 64000
C
D
E
F
G
Roll up the individual product forecasts and compare them with the family data. Use the
family forecasts to revise the individual forecasts (both dollars & units).
PART A
Product Family Forecast
Family $
Rolled-Up $ Rolled-Down $
Family
Forecast
Forecast
Sales Goal
1
50,000
46.000
60,000
2
50,000
64.000
50,000
3
75,000
65,000
90,000
Total
175,000
175,000
200,000
,
Use the FAMILY forecast to revise the individual item forecasts (in both dollars & units)
1
2
ROLL UP
Unit
3
Product Forecast
Dollars/Unit Dollar Forecast (goal)
ROLL DOWN
Dollar
Forecast
Unit Forecast
(goal)
A
10 $ 1,000.00 $ 10,000.00
5
B
15 $ 1,200.00 $
18,000.00
6
C
20 $ 900.00 $
18,000.00
17
TOTAL
$
46,000.00
18
5 $
5,000.00 $
25,000.00
19
E
3 $
7,000.00 $
21,000.00
20
F
2 $
9,000.00 $
18,000.00 xxXX XXXX
21
TOTAL
$
64,000.00
22
G
100 $
250.00 $
25,000.00 xxxxxXXXXXXXXXXXXXXXX
23
H
24
I
180 $
220 $
100.00 $
18,000.00 xx
100.00 $
22,000.00
25
TOTAL
XXXXXXXXXXXX
XXXXXXXXXXXX
XXXX XXXXXXXXXXXX
$…
arrow_forward
NING SYSTEM (ACADEMIC)
Series forecasting for Business ||
The F-test used in testing the significance of a regression model is
O a. Upper tailed test
O b. Two tailed test
O c. Lower tailed test
O d. None
OUS PAGE
arrow_forward
Q1. Brooke is a 32-year-old, single investment banker who lives in an apartment in a large city. After a particularly long and difficult workday, she relaxed in her apartment by reading through one business magazine and two fashion magazines. When questioned by a researcher the next day, she could clearly recall two holiday ads and vaguely remembered one ad for a personal computer from among the nearly 80 ads she had seen in the three magazines. However, she could recount in detail the articles that she had read and even recalled the titles of articles she had not read. How can you explain this?
arrow_forward
Q1) Forecasting is both art and science. Describe the situations where we use Qualitative forecasting techniques and quantitative forecasting techniques
arrow_forward
Here are the errors associated with a particular forecast over the past five months, in chronological order: 2, 5, 0, -5, -10.
Which of the following statements is (are) true?
I. The forecast was too high during the fifth month.
II. The mean error over these five months is -2.
III. The forecast was perfectly accurate during one of the months.
a. I only
Ob. Il only
O. Il only
d. I and III
Oe.I, Il and II
arrow_forward
A P A Aa A A
2。田、刻 T
Paragraph
Styles
Font
Voice
Editor
Exponential Smoothing Example
9
?
During the past 8 quarters, the Port of Baltimore has unloaded large
quantities of grain. (a = .10). The first quarter forecast was 175.
Quarter
4-5
Actual
1
180
168
Find the
3
159
forecast
for the 9th
quarter.
4
175
5.
190
205
180
182
Using a Trend Line
4-6
The demand for
electrical power
at N.Y.Edison
over the years
1997 – 2003 is
Year
Demand
1997
60
1998
65
1999
89
2000
92
given at the left.
Fin
2001
100
d the overall
2002
122
trend.
2003
110
What is the
demand for 2010
and 2011
2 words
Accessibility. Unavailable
D'Fosus
arrow_forward
A marketing analyst wants to examine the relationship between sales (in $1,000s) and advertising (in $100s) for firms in the food and beverage Industry and collects monthly data for 25 firms. He estimates the model
Sales-o Advertising. The following ANOVA table shows a portion of the regression results.
Regression
Residual
df
1
23
55
78.53
504.02
MS
78.53
21.91
T
3.58
arrow_forward
Scatter plot
Which are correct?
A) positive / negative/ cluster/ not applicable
B) linear / none linear
C) strong correlation / weak correlation
arrow_forward
a. A cell phone Company XYZ conducted an online survey that showed that 75 percent of customers put their number-one requirement for a new phone to be increased battery life. Only 22 percent of customers listed color choices as a large concern. Company XYZ currently offers 6 different color choices for its product and has a below-average battery life compared to competition. What should Company XYZ do with these survey results?
b. Company ABC recently conducted a survey that showed that 30 percent of customers will only shop there once and never use the company’s products again. What are some general ideas that can help increase customer loyalty?
c. Company #alltheshoes would like to find out what, if anything, customers know about its new running shoe, FancyShoe. Design two survey questions to find out the following: 1) Are customers aware of the product? 2) What brand image do customers have of theproduct?
arrow_forward
* Hame
Gradebook
Week 1 actice Asignmet-x
O ttps//appmyeducator.com/counelactivity.t/1844/270721506109441/
Which of the following is A curent trend in consumer behavior
Decreased customer need for accessing information prior to a purchase
OIncreased consumer reluctance to share data with businesses they interact with
O Availablity of premium options for devoted and loyal customers of a business
The need to create a seamless user experience on an easy to-use company website
Which of the folloving describes the form of data Kantar may present to marketers?
Ut providesa qualitative and quantitative segmentation opproach that oncovers the functional, sociall and emotional drivers of consumer behvior within a
given market.
Ditves companies a major presence on social networking sites as this alows them to interact with their current and potensal consumers in new ways
On stresses the subjective meaning of the consume's individual expertience and the idea that any behavior is subject to mutple…
arrow_forward
I DON'T SEE THIS ONE:
D.) Calculate the regression line. Compute the MAD and MSE for the regression line.
E.) Use your results for A.)-D.) to determine which forecast is best. Explain your results.
arrow_forward
13
true or false
Descriptive statistics are too basic therefore not very useful in data analytics.
arrow_forward
It wouldnt let me take a screenshot of the table so I had to copy and paste it in here. My question is: How do you Calculate a moving average forecast using the last 2 and 4 dates of stay. What is the prediction for 7/1/2021 for each technique?
Discussion Question 1 - 200 room hotel
Forecasts
MA 2 Errors
MA 4 Errors
ES (0.8) Errors
ES (0.5) Errors
Date
Day of Week
Rooms Sold
MA 2
MA 4
ES (0.8)
ES (0.5)
AE
APE
AE
APE
AE
APE
AE
APE
6/1/2021
Tuesday
123
6/2/2021
Wednesday
109
6/3/2021
Thursday
140
6/4/2021
Friday
199
6/5/2021
Saturday
179
6/6/2021
Sunday
140
6/7/2021
Monday
117
6/8/2021
Tuesday
132
6/9/2021
Wednesday
108
6/10/2021
Thursday
151…
arrow_forward
There is a bias towards under forecasting, though we cannot determine from the data provided whether that is severe bias or not
O There is a severe bias towards under forecasting
O Bias is negligible in this case
Question 22
A MAD (Mean Absolute Deviation) of 17.3 suggests which of the following?
O There is an over-forecasting bias of 17.3
O The standard deviation for the forecast data is 17.3
O All forecasts fall within 17.3 of the actual data
O On average, the forecasts miss by 17.3
O Without knowing the average, the MAD is useless
0 日
arrow_forward
18. When Creamy Layer Inc. planned to introduce a new ice cream flavor, its senior executives looked at the sales history of earlier introductions to forecast the sales for the newest flavor. This is an example of an analogy approach for new product forecasting. Select one: O True O False
arrow_forward
Question No. 1List the specific weaknesses of each of these approaches to developing a forecast:a. Consumer surveys.b. Salesforce composite.c. Committee of managers or executives.
Question No. 2What kinds of capacity problems do many elementary and secondary schools periodically experience? What are some alternatives to deal with those problems?
Question No. 3The XYZ company produces all type of office furniture. The “Executive Secretary” is a chair that has been designed using ergonomics to provide comfort during long office hours. The chair sells for $130. There are 480 minutes available during the day, and the average daily demand has been 50 chairs. There are eight tasks;
TaskTime (min)Immediate predecessor
A4-
B7-
C6A, B
D5C
E6D
F7E
G8E
I6F, G
Draw a precedence diagram of this operationWhat is the cycle time for this operation?What is the theoretical minimum number of workstations?Assign tasks to the workstationsWhat is the idle time per cycle?What is the efficiency of the…
arrow_forward
Q1. Consider the following scenario shown below. Discuss how the researcher should proceed; that is, determine the following, giving reasons:
Type of research question (exploratory, descriptive, or causal)
Type of research approach
The time horizon for the study
Sampling technique
Scenario
A specific department within an organization has a high turnover rate; this department has a shorter average tenure than other departments in the company. Skilled workers are leaving the firm. Mr. Ahmed (CEO) has no idea what is going on and wants to know more about what is happening.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337407137/9781337407137_smallCoverImage.gif)
BUSN 11 Introduction to Business Student Edition
Business
ISBN:9781337407137
Author:Kelly
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337386494/9781337386494_smallCoverImage.gif)
Essentials of Business Communication (MindTap Cou...
Business
ISBN:9781337386494
Author:Mary Ellen Guffey, Dana Loewy
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9780134474021/9780134474021_smallCoverImage.gif)
Accounting Information Systems (14th Edition)
Business
ISBN:9780134474021
Author:Marshall B. Romney, Paul J. Steinbart
Publisher:PEARSON
![Text book image](https://www.bartleby.com/isbn_cover_images/9781947172548/9781947172548_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781259929441/9781259929441_smallCoverImage.gif)
International Business: Competing in the Global M...
Business
ISBN:9781259929441
Author:Charles W. L. Hill Dr, G. Tomas M. Hult
Publisher:McGraw-Hill Education
![Text book image](https://www.bartleby.com/isbn_cover_images/9780357026595/9780357026595_smallCoverImage.gif)
Related Questions
- Question 3 An organization uses a business intelligence system to predict products that tend to be purchased together. This is an example of. O A) Regression Analysis B) Cluster Analysis C) REM Analysis D) Market Basket Analysisarrow_forwardQ1.What is the difference between the types of data 1- categorical data, 2- numerical data, with an example of each typearrow_forwardDivvy Bikes 2021 summer ridership has increased 30% from the ridership levels in 2020. Divvy's management attributes this to 2020 having fewer work places and recreation venues were open than in 2021. This is an example of which type of data analytics? Question 6 options: a) Descriptive b) Diagnostic c) Predictive d) Prescriptivearrow_forward
- Which test is best to test the hypothesis that multiple variances (2 or more) are equal? Group of answer choices 1. t test 2. proportions test 3. Mood's median test 4. Levene's test 5. Analysis of Variance (ANOVA)arrow_forwardMonth Actual Sales Naive Forecast- Absolute Value of (# of Product X) Sales Errors (# of Product X) Jan/19 Feb/19 Mar/19 Apr/19 May/19 Jun/19 Jul/19 Aug/19 Sep/19 Oct/19 Nov/19 Dec/19 Jan/20 1,860 2,033 3,556 4,211 6,250 7,990 10,250 9,850 9,980 9,990 7,895 5,353 - Explain the calculation method for the Naive Forecast model. the falnarrow_forwardQUESTION 2:The manager of YTL Computers wants to develop next year’s quarterly forecasts of salesrevenue for its brand laptops. The sales are seasonal and the company believes that thefollowing most recent eight quarters of sales should be representative of next year’ssales: Year Quarter Sales (millions of dollars) 1 1 9.2 1 2 5.4 1 3 4.3 1 4 14.1 2 1 10.3 2 2 6.4 2 3 5.4 2 4 16.0 Determine the forecast of next year’s quarterly sales revenue for this line of laptops.Show all your workings.arrow_forward
- Q5) Monthly sales for a six month period are as follows: Month SalesJan 18,000Feb 22,000Mar 16,000Apr 18,000May 20,000June 24,000 Compute the sales forecast for July using the following approaches: (1) Four-month moving average; (2) Weighted three-month moving average using .50 for June, .30 for May and .20 for April;(3) Exponential smoothing with α (smoothing constant) equal to .40, assuming a February forecast of 18,000arrow_forwardV. Let's Explore / Let's Create 1. Discuss the other types of forecasting methods that financial analysts use to predict future revenues. 2. Are there any several other factors that may need to be considered that affects the sales forecast? RUBRIC Criteria Poor (3 Points) Fair (7 Points) Fair Good (10 Points) Good Deerarrow_forward1. Give a specific example and scenario in Hospitality Industry that we can apply the Data Analysis Cycle. Identify the Problem Identify Available Data Sources Identify if Additional Data Sources are needed Statistical Analysis Implementation and Development Communicate Results Maintenancearrow_forward
- 06 A B xfx 64000 C D E F G Roll up the individual product forecasts and compare them with the family data. Use the family forecasts to revise the individual forecasts (both dollars & units). PART A Product Family Forecast Family $ Rolled-Up $ Rolled-Down $ Family Forecast Forecast Sales Goal 1 50,000 46.000 60,000 2 50,000 64.000 50,000 3 75,000 65,000 90,000 Total 175,000 175,000 200,000 , Use the FAMILY forecast to revise the individual item forecasts (in both dollars & units) 1 2 ROLL UP Unit 3 Product Forecast Dollars/Unit Dollar Forecast (goal) ROLL DOWN Dollar Forecast Unit Forecast (goal) A 10 $ 1,000.00 $ 10,000.00 5 B 15 $ 1,200.00 $ 18,000.00 6 C 20 $ 900.00 $ 18,000.00 17 TOTAL $ 46,000.00 18 5 $ 5,000.00 $ 25,000.00 19 E 3 $ 7,000.00 $ 21,000.00 20 F 2 $ 9,000.00 $ 18,000.00 xxXX XXXX 21 TOTAL $ 64,000.00 22 G 100 $ 250.00 $ 25,000.00 xxxxxXXXXXXXXXXXXXXXX 23 H 24 I 180 $ 220 $ 100.00 $ 18,000.00 xx 100.00 $ 22,000.00 25 TOTAL XXXXXXXXXXXX XXXXXXXXXXXX XXXX XXXXXXXXXXXX $…arrow_forwardNING SYSTEM (ACADEMIC) Series forecasting for Business || The F-test used in testing the significance of a regression model is O a. Upper tailed test O b. Two tailed test O c. Lower tailed test O d. None OUS PAGEarrow_forwardQ1. Brooke is a 32-year-old, single investment banker who lives in an apartment in a large city. After a particularly long and difficult workday, she relaxed in her apartment by reading through one business magazine and two fashion magazines. When questioned by a researcher the next day, she could clearly recall two holiday ads and vaguely remembered one ad for a personal computer from among the nearly 80 ads she had seen in the three magazines. However, she could recount in detail the articles that she had read and even recalled the titles of articles she had not read. How can you explain this?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
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337407137/9781337407137_smallCoverImage.gif)
BUSN 11 Introduction to Business Student Edition
Business
ISBN:9781337407137
Author:Kelly
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337386494/9781337386494_smallCoverImage.gif)
Essentials of Business Communication (MindTap Cou...
Business
ISBN:9781337386494
Author:Mary Ellen Guffey, Dana Loewy
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9780134474021/9780134474021_smallCoverImage.gif)
Accounting Information Systems (14th Edition)
Business
ISBN:9780134474021
Author:Marshall B. Romney, Paul J. Steinbart
Publisher:PEARSON
![Text book image](https://www.bartleby.com/isbn_cover_images/9781947172548/9781947172548_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781259929441/9781259929441_smallCoverImage.gif)
International Business: Competing in the Global M...
Business
ISBN:9781259929441
Author:Charles W. L. Hill Dr, G. Tomas M. Hult
Publisher:McGraw-Hill Education
![Text book image](https://www.bartleby.com/isbn_cover_images/9780357026595/9780357026595_smallCoverImage.gif)