Dealer Satisfaction Survey Scale 0 1 2 3 4 5 Sample North America Size 2010 1 0 2 14 22 11 50 2011 0 0 2 14 20 14 50 2012 1 1 1 8 34 15 60 2013 1 2 6 12 34 45 100 2014 2 3 5 15 44 56 125 South America 2010 0 0 0 2 6 2 10 2011 0 0 0 2 6 2 10 2012 0 0 1 4 11 14 30 2013 0 1 1 3 12 33 50 2014 1 1 2 4 22 60 90 Europe 2010 0 0 1 3 7 4 15 2011 0 0 1 2 8 4 15 2012 0 0 1 2 15 7 25 2013 0 0 1 2 21 6 30 2014 0 0 1 4 17 8 30 Pacific Rim 2010 0 0 1 2 2 0 5 2011 0 0 1 1 3 0 5 2012 0 0 1 1 3 1 6 2013 0 0 0 2 5 3 10 2014 0 0 1 2 7 2 12 China 2012 0 0 0 1 0 0 1 2013 0 0 1 4 2 0 7 2014 0 0 1 5 8 2 16 Survey Scale 0 1 2 3 4 5 2010 1 0 4 22 37 17 2011 0 0 4 19 37 20 2012 1 1 4 16 63 37 2013 1 3 9 23 74 87 2014 3 4 10 30 98 128 End User Satisfaction Sample North America 0 1 2 3 4 5 Size 2010 1 3 6 15 37 38 100 2011 1 2 4 18 35 40 100 2012 1 2 5 17 34 41 100 2013 0 2 4 15 33 46 100 2014 0 2 3 15 31 49 100 South America 2010 1 2 5 18 36 38 100 2011 1 3 6 17 36 37 100 2012 0 2 6 19 37 36 100 2013 0 2 5 20 37 36 100 2014 0 2 5 19 37 37 100 Europe 2010 1 2 4 21 36 36 100 2011 1 2 5 21 34 37 100 2012 1 1 4 26 37 31 100 2013 1 1 3 17 41 37 100 2014 0 1 2 19 45 33 100 Pacific Rim 2010 2 3 5 15 41 34 100 2011 1 2 7 15 41 34 100 2012 1 2 5 16 40 36 100 2013 0 2 4 17 40 37 100 2014 0 1 3 19 42 35 100 China 2012 0 3 3 6 28 10 50 2013 1 2 2 4 30 11 50 2014 0 1 1 3 31 14 50 Survey Scale 0 1 2 3 4 5 2010 5 10 20 69 150 146 2011 4 9 22 71 146 148 2012 3 10 23 84 176 154 2013 2 9 18 73 181 167 2014 0 7 14 75 186 168 Mower Unit Sales Month NA SA Europe Pacific China World Jan 10 6000 200 720 100 0 7020 Feb 10 7950 220 990 120 0 9280 Mar 10 8100 250 1320 110 0 9780 Apr 10 9050 280 1650 120 0 11100 May 10 9900 310 1590 130 0 11930 Jun 10 10200 300 1620 120 0 12240 Jul 10 8730 280 1590 140 0 10740 Aug 10 8140 250 1560 130 0 10080 Sep 10 6480 230 1590 130 0 8430 Oct 10 5990 220 1320 120 0 7650 Nov 10 5320 210 990 130 0 6650 Dec 10 4640 180 660 140 0 5620 Jan 11 5980 210 690 140 0 7020 Feb 11 7620 240 1020 150 0 9030 Mar 11 8370 250 1290 140 0 10050 Apr 11 8830 290 1620 150 0 10890 May 11 9310 330 1650 130 0 11420 Jun 11 10230 310 1590 140 0 12270 Jul 11 8720 290 1560 150 0 10720 Aug 11 7710 270 1530 140 0 9650 Sep 11 6320 250 1590 150 0 8310 Oct 11 5840 250 1260 160 0 7510 Nov 11 4960 240 900 150 0 6250 Dec 11 4350 210 660 150 0 5370 Jan 12 6020 220 570 160 0 6970 Feb 12 7920 250 840 150 0 9160 Mar 12 8430 270 1110 160 0 9970 Apr 12 9040 310 1500 170 0 11020 May 12 9820 360 1440 160 0 11780 Jun 12 10370 330 1410 170 0 12280 Jul 12 9050 310 1440 160 0 10960 Aug 12 7620 300 1410 170 0 9500 Sep 12 6420 280 1350 180 0 8230 Oct 12 5890 270 1080 180 0 7420 Nov 12 5340 260 840 190 0 6630 Dec 12 4430 230 510 180 0 5350 Jan 13 6100 250 480 200 0 7030 Feb 13 8010 270 750 190 0 9220 Mar 13 8430 280 1140 200 0 10050 Apr 13 9110 320 1410 210 0 11050 May 13 9730 380 1340 190 0 11640 Jun 13 10120 360 1360 200 0 12040 Jul 13 9080 320 1410 200 0 11010 Aug 13 7820 310 1490 210 0 9830 Sep 13 6540 300 1310 220 0 8370 Oct 13 6010 290 980 210 0 7490 Nov 13 5270 270 770 220 0 6530 Dec 13 5380 260 430 230 0 6300 Jan 14 6210 270 400 200 0 7080 Feb 14 8030 280 750 190 0 9250 Mar 14 8540 300 970 210 0 10020 Apr 14 9120 340 1310 220 5 10995 May 14 9570 390 1260 200 16 11436 Jun 14 10230 380 1240 210 22 12082 Jul 14 9580 350 1300 230 26 11486 Aug 14 7680 340 1250 220 14 9504 Sep 14 6870 320 1210 220 15 8635 Oct 14 5930 310 970 230 11 7451 Nov 14 5260 300 650 240 3 6453 Dec 14 4830 290 300 230 1 5651 Tractor Unit Sales Month NA SA Eur Pac China World Jan 10 570 250 560 212 0 1592 Feb 10 611 270 600 230 0 1711 Mar 10 630 260 680 240 0 1810 Apr 10 684 270 650 263 0 1867 May 10 650 280 580 269 0 1779 Jun 10 600 270 590 280 0 1740 Jul 10 512 264 760 290 0 1826 Aug 10 500 280 645 270 0 1695 Sep 10 478 290 650 263 0 1681 Oct 10 455 280 670 258 0 1663 Nov 10 407 290 888 240 0 1825 Dec 10 360 280 850 230 0 1720 Jan 11 571 320 620 250 0 1761 Feb 11 650 350 760 275 0 2035 Mar 11 740 390 742 270 0 2142 Apr 11 840 440 780 280 0 2340 May 11 830 470 690 290 0 2280 Jun 11 760 490 721 300 0 2271 Jul 11 681 481 680 312 0 2154 Aug 11 670 460 711 305 0 2146 Sep 11 640 460 695 290 0 2085 Oct 11 620 440 650 260 0 1970 Nov 11 570 436 680 250 0 1936 Dec 11 533 420 657 240 0 1850 Jan 12 620 510 610 250 10 2000 Feb 12 792 590 680 250 12 2324 Mar 12 890 610 730 260 20 2510 Apr 12 960 600 820 270 22 2672 May 12 1040 620 810 290 20 2780 Jun 12 1032 640 807 310 24 2813 Jul 12 1006 590 760 340 20 2716 Aug 12 910 600 720 320 31 2581 Sep 12 803 670 660 313 30 2476 Oct 12 730 630 630 290 37 2317 Nov 12 699 710 603 280 32 2324 Dec 12 647 570 570 260 33 2080 Jan 13 730 650 500 287 35 2202 Feb 13 930 680 590 290 50 2540 Mar 13 1160 724 620 300 63 2867 Apr 13 1510 730 730 310 68 3348 May 13 1650 760 740 330 70 3550 Jun 13 1490 800 720 340 82 3432 Jul 13 1460 840 670 350 80 3400 Aug 13 1390 830 610 341 90 3261 Sep 13 1360 820 599 330 100 3209 Oct 13 1340 810 560 320 102 3132 Nov 13 1240 827 550 300 110 3027 Dec 13 1103 750 520 290 114 2777 Jan 14 1250 780 480 200 111 2821 Feb 14 1550 805 523 210 121 3209 Mar 14 1820 830 560 220 123 3553 Apr 14 2010 890 570 230 120 3820 May 14 2230 930 590 253 130 4133 Jun 14 2490 980 600 270 136 4476 Jul 14 2440 1002 580 280 134 4436 Aug 14 2334 970 570 250 132 4256 Sep 14 2190 960 550 230 137 4067 Oct 14 2080 930 530 220 130 3890 Nov 14 2050 920 517 190 139 3816 Dec 14 2004 902 490 190 131 3717 Elizabeth Burke has asked you to do some preliminary analysis of the data in the Performance Lawn Equipment database First, she would like you to edit the worksheets Dealer Satisfaction and End User Satisfaction to display the total number of responses to each level of the survey scale across all regions for each year Second, she wants a count of the number of failures in the worksheet Mower Test Next, Elizabeth has provided you with prices for PLE products for the past 5 years Year Mower Price ($) Tractor Price ($) 2010 150 3,250 2011 175 3,400 2012 180 3,600 2013 185 3,700 2014 190 3,800 Create a new worksheet in the database to compute gross revenues by month and region, as well as worldwide totals, for each product using the data in Mower Unit Sales and Tractor Unit Sales Finally, she wants to know the market share for each product and region based on the PLE and industry sales data in the database Create and save these calculations in a new worksheet Summarize all your findings in a report to Ms Burke Elizabeth Burke has asked you to do some preliminary analysis of the data in the Performance Lawn Equipment database First, she would like you to edit the worksheets Dealer Satisfaction and End User Satisfaction to display the total number of responses to each level of the survey scale across all regions for each year Second, she wants a count of the number of failures in the worksheet Mower Test Next, Elizabeth has provided you with prices for PLE products for the past 5 years Year Mower Price ($) Tractor Price ($) 2010 150 3,250 2011 175 3,400 2012 180 3,600 2013 185 3,700 2014 190 3,800 Create a new worksheet in the database to compute gross revenues by month and region, as well as worldwide totals, for each product using the data in Mower Unit Sales and Tractor Unit Sales Finally, she wants to know the market share for each product and region based on the PLE and industry sales data in the database Create and save these calculations in a new worksheet Summarize all your findings in a report to Ms Burke

Question

Dealer Satisfaction Survey Scale  0 1 2 3 4 5 Sample North America Size 2010 1 0 2 14 22 11 50 2011 0 0 2 14 20 14 50 2012 1 1 1 8 34 15 60 2013 1 2 6 12 34 45 100 2014 2 3 5 15 44 56 125 South America 2010 0 0 0 2 6 2 10 2011 0 0 0 2 6 2 10 2012 0 0 1 4 11 14 30 2013 0 1 1 3 12 33 50 2014 1 1 2 4 22 60 90 Europe 2010 0 0 1 3 7 4 15 2011 0 0 1 2 8 4 15 2012 0 0 1 2 15 7 25 2013 0 0 1 2 21 6 30 2014 0 0 1 4 17 8 30 Pacific Rim 2010 0 0 1 2 2 0 5 2011 0 0 1 1 3 0 5 2012 0 0 1 1 3 1 6 2013 0 0 0 2 5 3 10 2014 0 0 1 2 7 2 12 China 2012 0 0 0 1 0 0 1 2013 0 0 1 4 2 0 7 2014 0 0 1 5 8 2 16 Survey Scale 0 1 2 3 4 5 2010 1 0 4 22 37 17 2011 0 0 4 19 37 20 2012 1 1 4 16 63 37 2013 1 3 9 23 74 87 2014 3 4 10 30 98 128 End User Satisfaction Sample North America 0 1 2 3 4 5 Size 2010 1 3 6 15 37 38 100 2011 1 2 4 18 35 40 100 2012 1 2 5 17 34 41 100 2013 0 2 4 15 33 46 100 2014 0 2 3 15 31 49 100 South America 2010 1 2 5 18 36 38 100 2011 1 3 6 17 36 37 100 2012 0 2 6 19 37 36 100 2013 0 2 5 20 37 36 100 2014 0 2 5 19 37 37 100 Europe 2010 1 2 4 21 36 36 100 2011 1 2 5 21 34 37 100 2012 1 1 4 26 37 31 100 2013 1 1 3 17 41 37 100 2014 0 1 2 19 45 33 100 Pacific Rim 2010 2 3 5 15 41 34 100 2011 1 2 7 15 41 34 100 2012 1 2 5 16 40 36 100 2013 0 2 4 17 40 37 100 2014 0 1 3 19 42 35 100 China 2012 0 3 3 6 28 10 50 2013 1 2 2 4 30 11 50 2014 0 1 1 3 31 14 50 Survey Scale 0 1 2 3 4 5 2010 5 10 20 69 150 146 2011 4 9 22 71 146 148 2012 3 10 23 84 176 154 2013 2 9 18 73 181 167 2014 0 7 14 75 186 168 Mower Unit Sales Month NA SA Europe Pacific China World Jan 10 6000 200 720 100 0 7020 Feb 10 7950 220 990 120 0 9280 Mar 10 8100 250 1320 110 0 9780 Apr 10 9050 280 1650 120 0 11100 May 10 9900 310 1590 130 0 11930 Jun 10 10200 300 1620 120 0 12240 Jul 10 8730 280 1590 140 0 10740 Aug 10 8140 250 1560 130 0 10080 Sep 10 6480 230 1590 130 0 8430 Oct 10 5990 220 1320 120 0 7650 Nov 10 5320 210 990 130 0 6650 Dec 10 4640 180 660 140 0 5620 Jan 11 5980 210 690 140 0 7020 Feb 11 7620 240 1020 150 0 9030 Mar 11 8370 250 1290 140 0 10050 Apr 11 8830 290 1620 150 0 10890 May 11 9310 330 1650 130 0 11420 Jun 11 10230 310 1590 140 0 12270 Jul 11 8720 290 1560 150 0 10720 Aug 11 7710 270 1530 140 0 9650 Sep 11 6320 250 1590 150 0 8310 Oct 11 5840 250 1260 160 0 7510 Nov 11 4960 240 900 150 0 6250 Dec 11 4350 210 660 150 0 5370 Jan 12 6020 220 570 160 0 6970 Feb 12 7920 250 840 150 0 9160 Mar 12 8430 270 1110 160 0 9970 Apr 12 9040 310 1500 170 0 11020 May 12 9820 360 1440 160 0 11780 Jun 12 10370 330 1410 170 0 12280 Jul 12 9050 310 1440 160 0 10960 Aug 12 7620 300 1410 170 0 9500 Sep 12 6420 280 1350 180 0 8230 Oct 12 5890 270 1080 180 0 7420 Nov 12 5340 260 840 190 0 6630 Dec 12 4430 230 510 180 0 5350 Jan 13 6100 250 480 200 0 7030 Feb 13 8010 270 750 190 0 9220 Mar 13 8430 280 1140 200 0 10050 Apr 13 9110 320 1410 210 0 11050 May 13 9730 380 1340 190 0 11640 Jun 13 10120 360 1360 200 0 12040 Jul 13 9080 320 1410 200 0 11010 Aug 13 7820 310 1490 210 0 9830 Sep 13 6540 300 1310 220 0 8370 Oct 13 6010 290 980 210 0 7490 Nov 13 5270 270 770 220 0 6530 Dec 13 5380 260 430 230 0 6300 Jan 14 6210 270 400 200 0 7080 Feb 14 8030 280 750 190 0 9250 Mar 14 8540 300 970 210 0 10020 Apr 14 9120 340 1310 220 5 10995 May 14 9570 390 1260 200 16 11436 Jun 14 10230 380 1240 210 22 12082 Jul 14 9580 350 1300 230 26 11486 Aug 14 7680 340 1250 220 14 9504 Sep 14 6870 320 1210 220 15 8635 Oct 14 5930 310 970 230 11 7451 Nov 14 5260 300 650 240 3 6453 Dec 14 4830 290 300 230 1 5651 Tractor Unit Sales Month NA SA Eur Pac China World Jan 10 570 250 560 212 0 1592 Feb 10 611 270 600 230 0 1711 Mar 10 630 260 680 240 0 1810 Apr 10 684 270 650 263 0 1867 May 10 650 280 580 269 0 1779 Jun 10 600 270 590 280 0 1740 Jul 10 512 264 760 290 0 1826 Aug 10 500 280 645 270 0 1695 Sep 10 478 290 650 263 0 1681 Oct 10 455 280 670 258 0 1663 Nov 10 407 290 888 240 0 1825 Dec 10 360 280 850 230 0 1720 Jan 11 571 320 620 250 0 1761 Feb 11 650 350 760 275 0 2035 Mar 11 740 390 742 270 0 2142 Apr 11 840 440 780 280 0 2340 May 11 830 470 690 290 0 2280 Jun 11 760 490 721 300 0 2271 Jul 11 681 481 680 312 0 2154 Aug 11 670 460 711 305 0 2146 Sep 11 640 460 695 290 0 2085 Oct 11 620 440 650 260 0 1970 Nov 11 570 436 680 250 0 1936 Dec 11 533 420 657 240 0 1850 Jan 12 620 510 610 250 10 2000 Feb 12 792 590 680 250 12 2324 Mar 12 890 610 730 260 20 2510 Apr 12 960 600 820 270 22 2672 May 12 1040 620 810 290 20 2780 Jun 12 1032 640 807 310 24 2813 Jul 12 1006 590 760 340 20 2716 Aug 12 910 600 720 320 31 2581 Sep 12 803 670 660 313 30 2476 Oct 12 730 630 630 290 37 2317 Nov 12 699 710 603 280 32 2324 Dec 12 647 570 570 260 33 2080 Jan 13 730 650 500 287 35 2202 Feb 13 930 680 590 290 50 2540 Mar 13 1160 724 620 300 63 2867 Apr 13 1510 730 730 310 68 3348 May 13 1650 760 740 330 70 3550 Jun 13 1490 800 720 340 82 3432 Jul 13 1460 840 670 350 80 3400 Aug 13 1390 830 610 341 90 3261 Sep 13 1360 820 599 330 100 3209 Oct 13 1340 810 560 320 102 3132 Nov 13 1240 827 550 300 110 3027 Dec 13 1103 750 520 290 114 2777 Jan 14 1250 780 480 200 111 2821 Feb 14 1550 805 523 210 121 3209 Mar 14 1820 830 560 220 123 3553 Apr 14 2010 890 570 230 120 3820 May 14 2230 930 590 253 130 4133 Jun 14 2490 980 600 270 136 4476 Jul 14 2440 1002 580 280 134 4436 Aug 14 2334 970 570 250 132 4256 Sep 14 2190 960 550 230 137 4067 Oct 14 2080 930 530 220 130 3890 Nov 14 2050 920 517 190 139 3816 Dec 14 2004 902 490 190 131 3717 Elizabeth Burke has asked you to do some preliminary analysis of the data in the Performance Lawn Equipment database  First, she would like you to edit the worksheets Dealer Satisfaction and End User Satisfaction to display the total number of responses to each level of the survey scale across all regions for each year  Second, she wants a count of the number of failures in the worksheet Mower Test  Next, Elizabeth has provided you with prices for PLE products for the past 5 years Year Mower Price ($) Tractor Price ($) 2010 150 3,250 2011 175 3,400 2012 180 3,600 2013 185 3,700 2014 190 3,800 Create a new worksheet in the database to compute gross revenues by month and region, as well as worldwide totals, for each product using the data in Mower Unit Sales and Tractor Unit Sales  Finally, she wants to know the market share for each product and region based on the PLE and industry sales data in the database  Create and save these calculations in a new worksheet  Summarize all your findings in a report to Ms  Burke Elizabeth Burke has asked you to do some preliminary analysis of the data in the Performance Lawn Equipment database  First, she would like you to edit the worksheets Dealer Satisfaction and End User Satisfaction to display the total number of responses to each level of the survey scale across all regions for each year  Second, she wants a count of the number of failures in the worksheet Mower Test  Next, Elizabeth has provided you with prices for PLE products for the past 5 years Year Mower Price ($) Tractor Price ($) 2010 150 3,250 2011 175 3,400 2012 180 3,600 2013 185 3,700 2014 190 3,800 Create a new worksheet in the database to compute gross revenues by month and region, as well as worldwide totals, for each product using the data in Mower Unit Sales and Tractor Unit Sales  Finally, she wants to know the market share for each product and region based on the PLE and industry sales data in the database  Create and save these calculations in a new worksheet  Summarize all your findings in a report to Ms  Burke

Accepted Answer

The Answer is in the image, click to view ...

Question

Dealer Satisfaction Survey Scale: 0 1 2 3 4 5 Sample North America Size 2010 1 0 2 14 22 11 50 2011 0 0

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Expert Fraud Investigation A Step By Step Guide

Students also viewed these Accounting questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question