University Business Analytics: Data Analysis & Decision Making Lab 1

This document presents a comprehensive solution to Business Analytics Lab 1, addressing questions related to data analysis and decision-making. The solution begins by identifying and classifying variables (categorical, ordinal, and nominal) from a survey dataset, creating column charts to visualize the data. It then recodes the data, transforming variables like gender, children, salary, and opinion, and generates new column charts. The solution also analyzes midterm and final exam scores, constructing histograms, calculating mean and median scores, and comparing student performance. Furthermore, it examines the Consumer Confidence Index (CCI) over time, interpreting trends and fluctuations, and analyzes average salary data. The assignment demonstrates various data analysis techniques, including descriptive statistics, data visualization, and interpretation of results, providing a detailed and insightful analysis of the provided datasets.

Business Analytics: Data Analysis & Decision Making
Lab work 1
Name of the Student
Name of the University
Author Note

Answer to question 1:
Part 1:
a] Categorical Variables
Age
Gender
State
Opinion
b] Ordinal Variable
Age
Opinion
c] Nominal Variables
Gender
State
Part 2:
Age
Young 87
Middle-aged 218
Elderly 94
Young Middle-aged Elderly
0
50
100
150
200
250
Age
Gender
Male 165
Female 234

Male Female
0
50
100
150
200
250
Gender
Row Labels
Count of
Person
Arizona 33
California 33
Florida 41
Illinois 38
Michigan 46
Minnesota 31
New York 46
Ohio 44
Texas 48
Virginia 39
Grand Total 399
Arizona
California
Florida
Illinois
Michigan
Minnesota
New York
Ohio
Texas
Virginia
0
10
20
30
40
50
60
Total
Total
Row Labels
Count of
Person
Agree 82

Disagree 85
Neutral 68
Strongly agree 86
Strongly
disagree 78
Grand Total 399
Agree Disagree Neutral Strongly agree Strongly
disagree
0
10
20
30
40
50
60
70
80
90
100
Total
Total
Part 3:
Row Labels
Count of
Person
Between $40K and $70K 119
Between $70K and
$100K 168
Greater than $100K 85
Less than $40K 27
Grand Total 399

Between $40K
and $70K Between $70K
and $100K Greater than
$100K Less than $40K
0
20
40
60
80
100
120
140
160
180
Total
Total

Answer to question 2:
Part 1:
Midterm
Bin
Frequenc
y
62 1
65.88889 2
69.77778 2
73.66667 15
77.55556 20
81.44444 18
85.33333 20
89.22222 8
93.11111 7
More 3
62
65.88888889
69.77777778
73.66666667
77.55555556
81.44444444
85.33333333
89.22222222
93.11111111
More
0
5
10
15
20
25
Histogram of Midterm Exam
Frequency
Bin
Frequency
Final Exam
Bin
Frequenc
y
56 1
60.88889 2
65.77778 4
70.66667 9
75.55556 14
80.44444 22
85.33333 14
90.22222 16
95.11111 9
More 5

56
60.88888889
65.77777778
70.66666667
75.55555556
80.44444444
85.33333333
90.22222222
95.11111111
More
0
5
10
15
20
25
Histogram of Final Exam
Frequency
Bin
Frequency
Part 2:
Mid Term Final
Mean 79.36458 80.03125
Median 79 79.5
Part 3:
The mean and median value differs because the number students scored are different.
Part 4:
The score has indicated that students performed better in final exam than midterm exam.
Part 5:
Difference in both exam
Mean 0.666666667
Median 2
Bin Frequency
-10 6
-7.77778 7
-5.55556 9
-3.33333 6
-1.11111 9
1.111111 8
3.333333 12
5.555556 17
7.777778 7
More 15

-10
-7.777777778
-5.555555556
-3.333333333
-1.111111111
1.111111111
3.333333333
5.555555556
7.777777778
More
0
4
8
12
16
Histogram
Frequency
Bin
Frequency

Answer to question 3:
Part 1:
Jun-1997
Jan-1998
Aug-1998
Mar-1999
Oct-1999
May-2000
Dec-2000
Jul-2001
Feb-2002
Sep-2002
Apr-2003
Nov-2003
Jun-2004
Jan-2005
Aug-2005
Mar-2006
Oct-2006
May-2007
Dec-2007
Jul-2008
Feb-2009
Sep-2009
0.0
20.0
40.0
60.0
80.0
100.0
120.0
140.0
160.0
CCI
Part 2:
US consumers have become less confident over time because the graph is continuously falling.
Part 3:
Initially, in 1997 the confidence was at peak; however, after 2000, it was started declining.
Nevertheless, from 2003 to 2007, there were huge swing following a huge declining after 2007 and
then a gradual increase after 2008.

Answer to question 4:
Part 1:
Average salary = 98573.06
Part 2:

Average salary = 75970.15
Part 3:
Part 4: