1008GBS T1 2021 Business Decision Making Assignment 2 Portfolio

This assignment is a data analysis portfolio completed for the 1008GBS Business Decision Making course. It involves the analysis of sales data, including total revenue, in-store revenue, and online revenue. The portfolio analyzes average expenditures on motorcycles and gear for both in-store and online customers. Furthermore, it includes a hypothesis testing section, where the student completes the six-step process to determine if customers will pay $350 for a product, which would increase the profit margin by 37.5%. The assignment utilizes provided sales data to answer research questions and draw conclusions based on the data analysis performed.

1008GBS Business Decision Making
T1 2021
ASSIGNMENT 2 – DATA ANALYSIS PORTFOLIO
STUDENT NAME
STUDENT ID
WORKSHOP DAY WORKSHOP TIME
QUESTIONS
Question 1
Total Revenue: $1740716
In-Store Revenue: $1134286
Online Revenue: $606430
1
3
5
7
9
11
13
15
17
19
21
23
25
27
29
31
33
35
37
39
41
43
45
47
$0
$5,000
$10,000
$15,000
$20,000
$25,000
$30,000
in store sales
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
$0
$5,000
$10,000
$15,000
$20,000
$25,000
$30,000
Online

1008GBS Business Decision Making
T1 2021
Question 2
Average Expenditure on Motorcycle
(in-store customers):
$21498
Average Expenditure on Motorcycle
(online customers):
$21374
In store Online
$21,300
$21,350
$21,400
$21,450
$21,500
$21,550
Average spending
Question 3
Average Expenditure on Gear
(in-store customers):
$2133
Average Expenditure on Gear
(online customers):
$3894

1008GBS Business Decision Making
T1 2021
In store Online
$0
$500
$1,000
$1,500
$2,000
$2,500
$3,000
$3,500
$4,000
$4,500
$2,133
$3,894
Average for gear
Question 4
Hypothesis testing
 In the spaces below, complete each step of the Six-Step Process of Hypothesis Testing
 Include the necessary information for each step
Step 1
(set up null and
alternative hypotheses)
H0: Is customers will pay $350 so that profit margin will increased by 37.5%.
H1: Is customer will not pay $350 so that profit margin will increased by 37.5%.
Step 2
(determine test statistic
and formula)
Regression analysis
Step 3
(specify the alpha) 5% level of significance to check whether Jacobi’s belief is justified and to help
him decide whether to stock this product
Step 4
(define decision rule)
To decrease the overall price by some unit.
Step 5
(calculate test statistic)
P=0.5631
Step 6
(answer research
question)
Yes the hypothesis will be accepted and customers will pay $350 so that profit
margin will increased by 37.5%.