CASE STUDY You have been hired as a data analyst by an organisation located in Sydney. Your main role is to finalise the process of data analysis and store the analytics results. The company has recently collected 3 sales and revenue sets of data from 3 different agencies.

Your first project is to analyse the data sets according to the organisations policies and procedures. Complete the following tasks to accomplish these purpose:

Questions:

A) The organisation has determined that they will only use one set of data. They have concluded that the set of data with the highest level of correlation between price and units sold is the most accurate. Your first task is to calculate the correlation coefficient for each set of data.

B) Analyse and explain in your own words the meaning of the correlation results obtained in Q1 and choose the set of data that corresponds to the organisations standard (highest correlation result). Remove the other sets of data as they will be considered to be incorrect based on the organisations policy.

C) Once you have chosen the relevant set of data you are required to report and store the results. Complete the following tasks to accomplish this purpose: a. Calculate the total Revenue. b. Calculate the average Revenue. c. Calculate the median. d. Identify the maximum and the minimum revenue value. e. Produce 2 different types of charts to report on Revenue. f. Analyse and interpret the revenue results for this set of data. Provide recommendations.

Data Set 1 Data Set 2 Data Set 3 Price Units Sold Revenue Price Units Sold Revenue Price Revenue 12120 12239 1200 1201 Units Sold 1200 1222 1244 1266 1200 1188 1176 1164 1153 1141 1130 1118 12359 12480 12602 12726 1201 1202 1202 1203 1204 1204 12120 12369 12622 12881 13145 13415 13690 13971 14257 14550 14848 12120 12585 13068 13569 14089 14630 10.10 10.30 10.51 10.72 10.93 11.15 11.37 11.60 11.83 12.07 12.31 1289 1312 1336 12850 12976 15191 15774 10.10 10.30 10.51 10.72 10.93 11.15 11.37 11.60 11.83 12.07 12.31 12.56 12.81 13.07 13.33 13.59 13.87 14.14 1360 1384 1205 10.10 10.30 10.51 10.72 10.93 11.15 11.37 11.60 11.83 12.07 12.31 12.56 12.81 13.07 13.33 13.59 13.87 14.14 1107 1096 13103 13232 13362 1409 16379 17007 17660 18337 1085 1434 1074 1064 1205 1206 1207 1207 1208 13492 13625 15153 15464 1460 1486 1053 1042 13758 13893 1513 1540 1208 14029 1032 1022 1012 14167 14306 1209 1210 1210 1568 1596 1625 1654 1684 14446 14.43 14.71 1001 991 14.43 14.71 14587 14730 1211 1211 1212 12.56 12.81 13.07 13.33 13.59 13.87 14.14 14.43 14.71 15.01 15.31 15.61 15.93 16.25 16.57 16.90 17.24 17.58 981 15781 16104 16435 16772 17116 17467 17825 18191 18564 18944 19333 19730 20134 20547 20969 21399 1714 1745 15.01 15.31 15.61 15.93 16.25 16.57 16.90 17.24 17.58 14875 19040 19771 20529 21317 22135 22984 23865 24781 25731 26718 27743 28807 29913 31060 32251 33489 34773 1213 15.01 15.31 15.61 15.93 16.25 16.57 972 962 952 943 933 924 915 906 15020 15168 15316 15466 15618 15771 15925 1213 1214 1214 1215 1777 1809 1841 1874 1216 16.90 17.24 17.58 1216 1217 1908 1943 1978 Data Set 1 Data Set 2 Data Set 3 Price Units Sold Revenue Price Units Sold Revenue Price Revenue 12120 12239 1200 1201 Units Sold 1200 1222 1244 1266 1200 1188 1176 1164 1153 1141 1130 1118 12359 12480 12602 12726 1201 1202 1202 1203 1204 1204 12120 12369 12622 12881 13145 13415 13690 13971 14257 14550 14848 12120 12585 13068 13569 14089 14630 10.10 10.30 10.51 10.72 10.93 11.15 11.37 11.60 11.83 12.07 12.31 1289 1312 1336 12850 12976 15191 15774 10.10 10.30 10.51 10.72 10.93 11.15 11.37 11.60 11.83 12.07 12.31 12.56 12.81 13.07 13.33 13.59 13.87 14.14 1360 1384 1205 10.10 10.30 10.51 10.72 10.93 11.15 11.37 11.60 11.83 12.07 12.31 12.56 12.81 13.07 13.33 13.59 13.87 14.14 1107 1096 13103 13232 13362 1409 16379 17007 17660 18337 1085 1434 1074 1064 1205 1206 1207 1207 1208 13492 13625 15153 15464 1460 1486 1053 1042 13758 13893 1513 1540 1208 14029 1032 1022 1012 14167 14306 1209 1210 1210 1568 1596 1625 1654 1684 14446 14.43 14.71 1001 991 14.43 14.71 14587 14730 1211 1211 1212 12.56 12.81 13.07 13.33 13.59 13.87 14.14 14.43 14.71 15.01 15.31 15.61 15.93 16.25 16.57 16.90 17.24 17.58 981 15781 16104 16435 16772 17116 17467 17825 18191 18564 18944 19333 19730 20134 20547 20969 21399 1714 1745 15.01 15.31 15.61 15.93 16.25 16.57 16.90 17.24 17.58 14875 19040 19771 20529 21317 22135 22984 23865 24781 25731 26718 27743 28807 29913 31060 32251 33489 34773 1213 15.01 15.31 15.61 15.93 16.25 16.57 972 962 952 943 933 924 915 906 15020 15168 15316 15466 15618 15771 15925 1213 1214 1214 1215 1777 1809 1841 1874 1216 16.90 17.24 17.58 1216 1217 1908 1943 1978