Can you see the documents attached. The first document has the instructions on them. The second document has the materials and task. Please follow the instruction document and then start using the excel document.
Documentation Shelly Cashman Excel 2019 | Module 8: SAM Project 1a Eastern Mobile ANALYZE DATA WITH CHARTS AND PIVOTTABLES Author:Humaddin Ahmed Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. Plans Mobile Phone Plans2021 Advertising Plan IDPlan Type# of LinesCost / LineTotal CostQ1 SalesQ2 SalesMonthAmountPlans Sold BA1Basic1$30.00$30.00$3,600$4,290Jan$6,50056 BA2Basic2$30.00$60.00$7,200$8,580Feb$7,85072 BA3Basic4$30.00$120.00$9,480$7,560Mar$8,27580 FA1Family2$40.00$80.00$8,720$7,440Apr$6,02550 FA2Family3$40.00$120.00$9,480$8,720May$6,40055 FA3Family6$40.00$240.00$11,050$15,120Jun$7,27555 IN1International1$60.00$60.00$1,740$960Jul$5,75060 IN2International2$60.00$120.00$3,960$4,440Aug$5,03555 SI1Single1$45.00$45.00$3,735$2,610Sep$7,52560 UN1Unlimited1$65.00$65.00$5,135$4,615Oct$8,07078 UN2Unlimited2$65.00$130.00$10,920$10,270Nov$8,25072 UN3Unlimited5$65.00$325.00$10,400$11,050Dec$8,57580 Q2 SalesBA1BA2BA3FA1FA2FA3IN1IN2SI1UN1UN2UN342908580756074408720151209604440261046151027011050 Customers Mobile Phone Customers CustomerYearsStatePlan IDPlan Type# of LinesOrder LocationPayment 50104DCBA2Basic2Online$60.00 50152NCFA2Family3Online$120.00 50191DEFA3Family6EM store$240.00 50203DCUN2Unlimited2Online$130.00 50235NCFA1Family2Phone store$80.00 50256MDSI1Single1Online$45.00 50274DCUN2Unlimited2Phone store$130.00 50297VAFA3Family6Online$240.00 50312DEIN1International1EM store$60.00 50333VAUN3Unlimited5Online$325.00 50371DEUN2Unlimited2Online$130.00 50391VABA3Basic4Online$120.00 51023MDFA2Family3EM store$120.00 51042DCSI1Single1Phone store$45.00 51064NCUN3Unlimited5Online$325.00 51086DCUN2Unlimited2Online$130.00 51106VAFA3Family6EM store$240.00 51125MDFA2Family3Phone store$120.00 51144DCBA3Basic4Phone store$120.00 51163VAUN1Unlimited1Online$65.00 51182DCFA1Family2Online$80.00 51205MDFA2Family3Online$120.00 51225VAFA3Family6Online$240.00 51286NCIN2International2Phone store$120.00 52012DEFA2Family3Online$120.00 52071MDUN2Unlimited2EM store$130.00 52084VAUN2Unlimited2Online$130.00 Orders Mobile Device DeliveriesMobile Device Orders Cust IDOrder IDDaysBinsCategoryTypeModelSales 511810-11212PhoneSmartphoneLarge$6,709 501510-22024Standard$5,928 510210-22136Voice phoneFlip$1,046 501010-23708TabletSlateMini$2,188 510410-3375Standard$3,075 503110-4996HybridStandard$4,210 502310-5535Large$2,150 510810-6630WearableActivity trackerFitness$2,568 501910-8822Health$1,205 512011-0377WatchStandard$2,677 511011-05410Rugged$1,345 502011-0983 512211-3642 511211-3660 510611-5991 502911-6331 502511-7210 503911-8827 511412-0760 502712-17110 503712-5041 511612-7543 503312-7640 BinFrequencyCumulative % 21356.52% 4369.57% 6382.61% 8291.30% More2100.00% Histogram Frequency2468More133322Cumulative %2468More0.565217391304347780.695652173913043460.826086956521739140.913043478260869511Bin Frequency Customers by Plan PlansTotal Payments# of CustomersSum of # of Lines Basic$300310 BA2$6012 DC$6012 BA3$24028 DC$12014 VA$12014 Family$1,7201143 FA1$16024 DC$8012 NC$8012 FA2$600515 DE$12013 MD$36039 NC$12013 FA3$960424 DE$24016 VA$720318 International$18023 IN1$6011 DE$6011 IN2$12012 NC$12012 Single$9022 SI1$9022 DC$4511 MD$4511 Unlimited$1,495923 UN1$6511 VA$6511 UN2$780612 DC$39036 DE$13012 MD$13012 VA$13012 UN3$650210 NC$32515 VA$32515 Grand Total$3,7852781 Sales Pivot Row LabelsTotal Q2 SalesTotal Q1 Sales Basic$20,430$20,280 Family$31,280$29,250 International$5,400$5,700 Single$2,610$3,735 Unlimited$25,935$26,455 Grand Total$85,655$85,420 Location Pivot Sum of PaymentColumn Labels BasicBasic TotalFamilyFamily TotalInternationalInternational TotalSingleSingle TotalUnlimitedUnlimited TotalGrand Total Row LabelsDCVADCDEMDNCVADENCDCMDDCDEMDNCVA EM store$240$120$240$600$60$60$130$130$790 Online$60$120$180$80$120$120$120$480$920$45$45$260$130$325$520$1,235$2,380 Phone store$120$120$120$80$200$120$120$45$45$130$130$615 Grand Total$180$120$300$80$360$360$200$720$1,720$60$120$180$45$45$90$390$130$130$325$520$1,495$3,785 Payments by Order Location Basic - DCEM storeOnlinePhone store60120Basic - VAEM storeOnlinePhone store120Family - DCEM storeOnlinePhone store80Family - DEEM storeOnlinePhone store240120Family - MDEM storeOnlinePhone store120120120Family - NCEM storeOnlinePhone store12080Family - VAEM storeOnlinePhone store240480International - DEEM storeOnlinePhone store60International - NCEM storeOnlinePhone store120Single - DCEM storeOnlinePhone store45Single - MDEM storeOnlinePhone store45Unlimited - DCEM storeOnlinePhone store260130Unlimited - DEEM storeOnlinePhone store130Unlimited - MDEM storeOnlinePhone store130Unlimited - NCEM storeOnlinePhone store325Unlimited - VAEM storeOnlinePhone store520