1.Using the Excel file Sales transaction find the following15 Marks a.Identify the levels of measurement for each variables b.Construct a cross tabulation to find the
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/66731cf1de8c3_08166731cf19c9a5.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/66731cf2673f6_08266731cf241f92.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/66731cf2e9f57_08266731cf2b3c24.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/66731cf372aea_08366731cf34b35b.jpg)
1.Using the Excel file Sales transaction find the following15 Marks
a.Identify the levels of measurement for each variables
b.Construct a cross tabulation to find the number of transactions by product and region, total amount of revenue by region, and total revenue by region and product.
c.Calculate the descriptive statistics and infer.
d.Find the average sales by source (web or e-mail). Do you think this information, could be useful in advertising? Explain how and why or why not.
e.Find the proportion of customers who used PayPal and the proportion of customers who used credit cards. Also find the proportion that purchased a book and the proportion that purchased a DVD.
f.Summarize your findings a present a brief report
Sales Transactions: July 14 Transacti on Time Cust ID Region Payment Code Source Amount Product Of Day 10001 Eas Paypal 93816545 Web $20.19 DVD 22:19 10002 West Credit 74083490 Web $17.85 DVD 13:27 10003 North Credit 64942368 Web $23.98 DVD 14:27 10004 West Paypal 70560957 Email $23.51 Book 15:38 10005 South Credit 35208817 Web $ 15.33 Book 15:2: 10006 West Paypal 20978903 Email $17.30 DVD 13:11 10007 East Credit 80103311 Web $177.72 Book 21:59 10008 West Credit 14132683 Web $21.76 Book 4:04 10009 West Paypal 40128225 Web $15.92 DVD 19:35 10010 South Paypal 49073721 Web $23.39 DVD 13:26 10011 South Paypal 57398827 Email $24.45 Book 14:17 10012 East Credit 34400661 Web $20.39 Book 1:0 10013 North Paypal 54242587 Web $19.54 DVD 10:04 10014 East Credit 62597750 Web $151.67 Book 9:09 10015 West Credit 51555882 Web $21.01 DVD 5:05 10016 West Paypal 54332964 Web $22.91 DVD 20:29 10017 West Credit 26623353 Email $19.51 Book 15:03 10018 West Paypal 78594431 Web $20.16 Book 18:54 10019 West Credit 89385348 Web $17.53 DVD 20:00 10020 West Credit 69868417 Web $17.74 DVD 12:37 10021 North Paypal 59660276 Email $17.16 Book 5:05 10022 West Credit 25456590 Web $205.58 Book 20:42 10023 South Credit 93283893 Email $ 18.12 Book 10:12 10024 West Credit 45991123 Web $20.04 DVD 16:27 10025 West Paypal 79121745 Email $23.21 DVD 20:22 10026 West Credit 80685117 Email $22.79 DVD 19:58 10027 West Credit 56686474 Web $16.91 DVD 19:44 10028 South Credit 25270813 Web $20.22 Book 19:2 10029 East Paypal 59736137 Web $18.36 DVD 15:48 10030 West Paypal 79615191 Email $206.80 Book 18:14 10031 North Paypal 55365094 Email $17.95 DVD 15:15 10032 East Credit 79118930 Web $18.29 Book 12:59 10033 South Paypal 84470584 Web $18.55 Book 17:38 10034 West Credit 71097636 Web $ 18.82 Book 2:02 10035 West Credit 73290219 Web $16.35 Book 14:05 10036 East Credit 92093991 Web $ 16.30 DVD 4:04 10037 South Paypal 11165609 Web $217 Book 0:00 10038 East Credit 79944825 Web $16.15 DVD 10:28 10039 North Credit 59537977 Web $18.78 DVD 5:05 10040 South Credit 37870882 Web $150.99 Book 7:0710041 West Credit 59747081 Web $21.39 DVD 19:20 10042 West Credit 33511221 Web $16.60 DVD 16:23 10043 South Paypal 69676186 Web $23.81 Book 7:07 10044 South Credit 72150231 Web $15.87 Book 13:46 10045 West Credit 64874923 Web $20.82 DVD 9:09 10046 South Credit 79755506 Web $21.15 Book 6:06 10047 South Paypal 43322747 Web $19.66 DVD 18:50 10048 West Paypal 57979095 Email $21.02 DVD 3:03 10049 West Credit 96485037 Web $23.13 DVD 6:06 10050 West Paypal 85636284 Web $ 15.17 DVD 18:53 10051 East Paypal 42519148 Web $209.51 Book 9:09 10052 West Credit 59845178 Web $16.03 Book 17:28 10053 North Credit 47961093 Email $16.17 DVD 13:18 10054 East Credit 32857450 Web $ 18.37 DVD 8:08 10055 East Credit 23437096 Web $15.96 Book 8:08 10056 North Paypal 23846199 Web $19.29 Book 0:00 10057 West Paypal 15630914 Email $16.49 DVD 19:59 10058 East Paypal 64471213 Web $18.12 Book 17:35 10059 East Credit 70288635 Web $18.22 DVD 15:52 10060 East Credit 46067931 Web $18.32 Book 10:15 10061 West Credit 73400603 Web $23.77 DVD 19:53 10062 East Paypal 31794035 Web $24.35 Book 15:16 10063 South Credit 72954240 Email $20.13 DVD 13:55 10064 North Credit 12364851 Email $20.77 DVD 13:34 10065 North Credit 19974213 Email $ 16.98 DVD 19:21 10066 East Credit 68753569 Email $19.40 Book 15:02 10067 East Paypal 77232784 Email $23.49 Book 4:04 10068 South Credit 94731015 Web $ 15.58 Book 11:39 10069 South Credit 49007475 Web $21.94 DVD 20:19 10070 South Credit 71384600 Email $229.73 Book 1:01 10071 West Credit 15282110 Web $16.06 Book 10:31 10072 South Credit 87012305 Web $22.21 DVD 10:01 10073 West Credit 27742544 Email $21.58 DVD 0:00 10074 North Paypal 97981670 Email $16.09 Book 3:03 10075 East Credit 83670405 Email $ 16.10 DVD 10:13 10076 East Credit 99063530 Web $15.95 DVD 0:00 10077 South Credit 25978103 Email $17.77 Book 1:01 10078 North Credit 81824666 Web $19.30 DVD 11:24 10079 West Paypal 86833489 Web $21.75 Book 10:23 10080 West Paypal 73512800 Web $20.51 Book 11:29 10081 North Credit 11673210 Web $16.14 DVD 4:04 10082 West Paypal 76787805 Email $157.76 Book 19:02 10083 South Credit 34610946 Web $21.55 Book 9:09 10084 North Paypal 69586073 Web $21.85 DVD 12:24 10085 East Credit 87017416 Web $21.70 DVD 13:3310086 East Paypal 37371293 Web $20.31 Book 19:26 10087 East Credit 27497600 Email $23.62 Book 22:20 10088 East Credit 29510284 Web $216.37 Book 10:20 10089 North Paypal 40878208 Web $21.99 DVD 3:03 10090 West Credit 83375454 Email $18.20 DVD 5:05 10091 East Credit 61236522 Email $17.31 Book 0:00 10092 West Credit 68788857 Web $23.94 Book 16:08 10093 West Paypal 58309878 Email $174.25 Book 18:31 10094 West Paypal 84324439 Web $20.26 DVD 4:04 10095 North Credit 90647889 Web $18.73 DVD 0:00 10096 North Paypal 31225474 Web $22.88 Book 13:09 10097 West Paypal 79286039 Web $19.15 DVD 14:44 10098 South Credit 69628094 Email $15.33 Book 1:01 10099 West Paypal 19891764 Web $20.82 DVD 18:0 10100 West Credit 21992857 Web $20.61 DVD 18:29 10101 East Credit 40572972 Web $16.43 DVD 11:23 10102 West Credit 80218197 Web $21.10 DVD 2:02 10103 North Paypal 72072353 Email $21.64 Book 22:40 10104 West Paypal 44250706 Email $ 18.06 Book 16:00 10105 East Credit 31062653 Web $ 19.35 Book 10:0 10106 North Credit 84047393 Web $23.70 DVD 19:02 10107 North Credit 59891368 Web $18.93 Book 9:09 10108 North Credit 47234209 Email $16.83 Book 16:20 10109 West Credit 47893510 Web $22.19 Book 18:52 10110 West Credit 23513829 Web $23.90 Book 19:40 10111 East Credit 20993720 Web $17.47 DVD 10:53 10112 West Credit 58724265 Email $209.37 Book 20:11 10113 North Credit 47687764 Web $ 18 DVD 8:08 10114 East Credit 53008101 Web $22.83 Book 10:17 10115 East Credit 68494188 Email $ 20.31 DVD 14:34 10116 South Paypal 40357817 Web $22.06 DVD 11:07 10117 North Paypal 91328383 Web $15.22 Book 10:39 10118 South Paypal 51497241 Web $20.60 DVD 20:46 10119 East Credit 42829269 Web $18.25 DVD 20:42 10120 East Credit 56174714 Web $174.18 Book 12:42 10121 North Credit 17210514 Email $19.58 DVD 22:31 10122 West Paypal 40504819 Web $17.91 Book 19:14 10123 West Credit 58186991 Web $22.90 Book 12:16 10124 North Paypal 46376047 Web $22.26 Book 17:50 10125 South Credit 95760408 Web $ 19.04 Book 15:23 10126 East Credit 73024614 Web $17.42 DVD 5:05 10127 West Paypal 63167563 Web $18.54 Book 19:30 10128 North Credit 83800724 Web $ 19.74 DVD 12:49 10129 West Credit 11739665 Web $22.03 DVD 14:49 10130 West Paypal 74393415 Web $236.49 Book 16:2410131 South Paypal 30372359 Email $19.30 DVD 17:00 10132 East Credit 47768495 Email $23.73 DVD 16:57 10133 West Paypal 74154714 Web $19.96 Book 16:50 10134 East Credit 33525138 Web $20.75 DVD 15:02 10135 South Paypal 84542864 Web $22.37 DVD 8:08 10136 West Credit 24537107 Email $24.03 DVD 11:14 10137 West Credit 74241899 Web $24.59 DVD 4:04 10138 West Paypal 33200655 Email $155.91 Book 18:38 10139 East Credit 89349547 Email $16.43 Book 9:09 10140 South Paypal 83528887 Web $15.71 Book 16:44 10141 West Paypal 21113649 Web $ 15.19 Book 16:22 10142 West Paypal 35126822 Web $21.35 DVD 17:54 10143 West Credit 98692914 Web $19.47 DVD 18:17 10144 West Credit 96105789 Web $21.49 DVD 9:09 10145 East Paypal 72991138 Web $22.20 DVD 12:29 10146 East Paypal 77775458 Web $21.15 DVD 7:07 10147 East Credit 71420485 Web $ 15.16 DVD 11:19 10148 East Credit 55498553 Email $15.71 Book 9:09 10149 West Paypal 93904863 Web $24.65 Book 20:41 10150 West Paypal 37998977 Email $24.88 Book 15:2 10151 East Paypal 24697741 Email $17.49 Book 21:46 10152 West Credit 77906388 Web $19.71 DVD 7:07 10153 South Credit 79915334 Web $17.33 Book 2:02 10154 West Credit 50624253 Web $15.56 DVD 21:07 10155 East Credit 32851119 Web $ 18.94 DVD 20:00 10156 North Credit 79812666 Web $22.86 Book 16:02 10157 South Paypal 45319579 Web $15.18 Book 6:06 10158 South Credit 44466808 Web $22.46 Book 17:44 10159 West Credit 26950438 Email $21.39 Book 17:17 10160 South Credit 66610830 Email $22.17 DVD 10:23 10161 North Paypal 45496161 Web $234.63 Book 9:09 10162 North Paypal 57085887 Web $24.97 Book 22:11 10163 West Credit 86987062 Web $15.72 Book 10:53 10164 East Credit 75029194 Web $24.35 Book 8:08 10165 West Paypal 16712886 Email $16.09 Book 3:08 10166 West Credit 39307303 Web $23.51 Book 16:18 10167 North Paypal 41334963 Web $22.59 Book 16:5: 10168 East Credit 58630343 Web $15.59 DVD 9:09 10169 West Credit 87184105 Web $190.81 Book 21:57 10170 West Paypal 35358631 Web $21.12 Book 16:40 10171 North Credit 55749730 Web $24.60 DVD 20:38 10172 North Paypal 62374456 Web $21.22 DVD 12:20 10173 West Credit 84556568 Web $21.78 DVD 7:07 10174 West Credit 57605353 Web $16.54 DVD 17:52 10175 East Credit 45033697 Email $177.32 Book 15:5210176 South Credit 33917941 Web $21.50 Book 10:53 10177 West Paypal 39654675 Web $24.65 DVD 20:45 10178 North Paypal 47532285 Web $19.43 DVD 9:09 10179 West Credit 85998809 Web $21.12 DVD 20:13 10180 West Credit 34960635 Web $18.10 DVD 20:32 10181 East Credit 85117076 Email $24.40 Book 13:25 10182 South Credit 67865323 Web $19.37 Book 21:48 10183 West Credit 55061563 Email $19.17 DVD 0:00 10184 South Credit 58022125 Email $241.77 Book 9:09 10185 West Paypal 25679000 Web $19.65 Book 20:46 10186 West Paypal 35078468 Web $ 19.88 Book 8:08 10187 West Paypal 75772325 Web $ 15.18 DVD 12:30 10188 West Paypal 25433486 Web $15.08 Book 12:15 10189 North Paypal 65056232 Web $23.74 Book 5:05 10190 North Credit 6077043 Web $19.44 Book 9:09 10191 South Credit 68380003 Web $17.70 DVD 2:02 10192 West Credit 92733708 Web $16.99 DVD 17:34 10193 East Paypal 17547620 Email $16.13 Book 13:37 10194 West Paypal 95291830 Web $24.80 DVD 20:28 10195 West Paypal 49471722 Web $17.52 Book 20:3 10196 North Paypal 70336893 Web $23.63 Book 19:47 10197 West Credit 44142213 Web $23.03 DVD 11:27 10198 West Paypal 69832322 Web $21.03 DVD 19:18 10199 South Credit 54284580 Web $21.88 Book 3:03 10200 South Credit 69967343 Email $24.86 Book 17:27