Exploratory Data Analysis of Phone Sales Information, Exams of Health sciences

Download Exploratory Data Analysis of Phone Sales Information and more Exams Health sciences in PDF only on Docsity!

MATH533: EXPLORATORY DATA

ANALYSIS2023/24.

COURSE PROJECT: PART A

1 | P a g e A. Introduction For the exploratory data analysis, I will be providing a managerial statistical analysis from the data provided in the chart below. The data chart contains phone sales information obtained from 100 calls, with dependent and independent variables over a week period. The variables provided in the data chart are: ➢ Methods of sales training given to employees ➢ Years of employee experience at the call center ➢ Average time spent on calls per week ➢ Sales generated per instance For calculation purposes, n = 100 and Variables = Sales (Y), Calls (X1), Time (X3) Years (X3), Type Sales (Y) Calls (X1) Time (X2) Years (X3) Type 48 171 13.0 5 ONLI NE 32 139 16.9 4 NONE 44 165 15.7 3 ONLI NE 47 186 13.5 3 ONLI NE 41 180 14.0 2 ONLI NE 46 184 12.7 5 ONLI NE 32 120 19.9 3 NONE 46 172 14.7 3 GROU P 42 161 13.2 1 GROU P 33 143 15.4 3 NONE 42 181 11.5 4 ONLI NE 50 148 16.0 0 NONE 42 140 17.5 2 GROU P 41 198 13.2 2 ONLI NE

3 | P a g e

43 174 12.7 2 ONLI

NE

42 168 16.4 0 ONLI

NE

49 178 15.1 3 ONLI

NE

41 164 17.8 3 GROU

P

40 191 19.0 5 ONLI

NE

37 132 10.0 0 NONE

36 140 15.7 1 NONE

46 171 14.9 5 ONLI

NE

41 170 12.3 0 ONLI

NE

49 153 19.0 3 GROU

P

42 154 14.3 2 GROU

P

37 142 13.9 3 NONE

37 130 16.9 2 NONE

21 177 17.0 0 ONLI

NE

39 160 14.3 4 NONE

44 134 19.4 5 GROU

P

49 131 14.6 1 GROU

P

35 130 19.4 4 NONE

46 183 15.4 4 ONLI

NE

43 169 14.0 5 GROU

P

41 155 16.0 2 ONLI

NE

48 182 13.0 2 ONLI

NE

39 140 12.4 1 NONE

40 157 15.4 1 ONLI

NE

48 167 14.8 3 ONLI

NE

50 144 15.8 2 NONE

44 168 12.4 2 GROU

P

43 175 13.6 5 GROU

P

33 150 14.9 2 GROU

P

4 | P a g e

32 155 17.9 1 GROU

P

46 163 16.6 2 ONLI

NE

48 162 14.5 4 GROU

P

56 189 15.0 3 ONLI

NE

44 153 15.3 2 ONLI

NE

34 158 14.2 3 ONLI

NE

43 160 10.9 4 ONLI

NE

33 173 17.5 1 ONLI

NE

49 178 18.3 2 GROU

P

50 189 14.3 1 ONLI

NE

52 184 11.4 4 ONLI

NE

45 174 13.6 2 ONLI

NE

48 188 13.6 0 ONLI

NE

35 149 15.6 1 GROU

P

44 159 14.6 2 GROU

P

44 160 14.8 2 ONLI

NE

6 | P a g e B. Discuss the first individual variable, using graphical, numerical summary and interpretation. For the first individual variable, I decided to analyze the type of training, provided in the data set. There are three different types of training, which includes: ➢ Online training ➢ None or no training ➢ Group training This variable is considered to be a qualitative variable; it cannot be measured numerically. I decided to tally up the sums and create a table and pie-doughnut chart to represent my findings. The results are:

7 | P a g e ➢ 50% employees received online training ➢ 30% employees received group training ➢ 20% employees did not receive training C. Discuss the second individual variable, using graphical, numerical summary and interpretation. For the second variable, I decided to analyze the employees’ years of experience while working at the call center. I wanted to find TYPE OF TRAINING TALLY COUNT OF TYPE GROUP ||||||||||||||||||||||| |||||| 30 NONE |||||||||||||||||||| 20 ONLINE ||||||||||||||||||||||| ||||||||||||||||||||||| |||| 50 COUNT OF TYPE 30 50 20 GROUPNONEONLINE PIE CHART - DOUGHNUT

9 | P a g e employees with different years of experience. The data set only provides information from 0 – 5 years of experience. One can only assume that this can be a fairly new company competing in the market. If my assumption is correct, I created a simple logic chart and line graph to support my findings. BAR CHART EXPERIENCE 35 30 29 25 20 22 20 COUN T 15 10 5 0 9 Frequency (^10 ) 012345 M 0 ore NUMBER OF YEARS

10 | P a g e ➢ First year, hired and started with 10 employees ➢ Second year, hired 10 employees ➢ Third year, hired 20 employees ➢ Fourth year, hired 29 employees ➢ Fifth year, hired 22 employees ➢ Lastly, 9 more employees were hired

12 | P a g e spent on conducting sales calls. Using the sample of 100, the company spent an average of 15.338 minutes per call. With the assistance of minitab, I was able to create a histogram to show my findings. ➢ Descriptive Statistics: Time (X2) VARIAB LE

PERC

EN

T

MEA

N

STDE

V

MEDI

A

N

N FOR MODE MO

DE

TIME

(X2)

13 | P a g e E. Discuss the first pairing of variables, using graphical, numerical summary and interpretation. For the first pairing of variables, I decided to analyze the amount of calls made versus the amount of sales. I wanted to analyze the relationship between both calls and sales using a scatter gram graph, with the assistance of minitab. The scatter gram provides some relationship with the trend line inclined directed positively, however, it is very minimal. I decided to select correlation coefficient to determine how strong the calls vs sales HISTOGRAM GRAPH

15 | P a g e the accuracy and is represented as a value between 0 and 1; indicates the extent that the dependent variable is predicted (Investopedia, 2018). For this analysis, amount of sales (y) is the dependent variable, and the amount sales is independent (X1) calls. Therefore, R 2 of 0. means that only 10% of the variance in (Y) Sales is predictable from (X) the calls made. Some important key details regarding particular test that have statistical significance: ➢ Value of P- does not exceed 50% ➢ P-value of .0001, statistical significance having enough evidence to suggest that the amount of calls has some sort of relationship with sales ➢ P- value =. SCATTER GRAM GRAPH

16 | P a g e F. Discuss the second pairing of variables, using graphical, numerical summary and interpretation. For the second pairing of variables, I decided to analyze the relationship between the

18 | P a g e

YEARS

(X3)

19 | P a g e

PIE

GRAPH

PIE: DOUGHNUT CHART OF YEARS (X3)

With the assistance of minitab, I was able to determine if there was a strong relationship using the scatter gram. There was no positive or negative relationship