Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please look at the following data set and analyze it. Then, write 4 comments/analyses on the data. Will give thumbs up, thank you. Red: bottom

Please look at the following data set and analyze it. Then, write 4 comments/analyses on the data. Will give thumbs up, thank you.

Red: bottom 10%

Green: Top 10%

Yellow/orange: Above average %

image text in transcribed

A B TI 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 48 47 48 49 50 51 52 Store Number 1 2 3 4 5 8 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 MS D E Year Branch Opened City State name 2010 Montgomery Alabama 2012 Juneau Alaska 2015 Phoenix Arizona 2014 Little Rock Arkansas 2011 Sacramento California 2011 Denver Colorado 2012 Hartford Connecticut 2013 Dover Delaware 2010 Tallahassee Florida 2013 Atlanta Georgia 2011 Honolulu Hawaii 2014 Boise Idaho 2015 Springfield Illinois 2012 Indianapolis Indiana 2013 Des Moines lowa 2015 Topeka Kansas 2015 Frankfort Kentucky 2010 Baton Rouge Louisiana 2011 Augusta Maine 2012 Annapolis Maryland 2010 Boston Massachusetts 2013 Lansing Michigan 2014 Saint Paul Minnesota 2014 Jackson Mississippi 2013 Jefferson City Missouri 2012 Helena Montana 2013 Lincoln Nebraska 2015 Carson City Nevada 2015 Concord New Hampshire 2010 Trenton New Jersey 2011 Santa Fe New Mexico 2012 Albany New York 2010 Raleigh North Carolina 2013 Bismarok North Dakota 2014 Columbus Ohio 2014 Oklahoma City Oklahoma 2013 Salem Oregon 2012 Harrisburg Pennsylvania 2013 Providence Rhode Island 2015 Columbia South Carolina 2015 Pierre South Dakota 2010 Nashville Tennessee 2011 Austin Texas 2012 Salt Lake City Utah 2010 Montpelier Vermont 2013 Richmond Virginia 2014 Olympia Washington 2014 Charleston West Virginia 2013 Madison Wisconsin 2012 Cheyenne Wyoming Store Manager Jackson Aiden Liam Lucas Noah Mason Ethan Caden Jacob Logan Jayden Elijah Jack Luke Michael Benjamin Alexander James Jay Caleb Connor William Carter Ryan Oliver Matthew Daniel Gabriel Henry Owen Grayson Dylan Landon Isaac Nicholas Wyatt Nathan Andrew Cameron Dominic Joshua Eli Sebastian Hunter Brayden David Samuel Evan Gavin Christian G Code for Total Abbrev Regional Items Sold iation Area (Qty Total Sales Net Profit AL 1,684 S 2,000,100 $ 300,015 AK 1,295 $ 1,988,553 $ 218,741 AZ 1,706 S 1.977,006 237,241 AR 1,455 $ 1,965,459 S 255,510 CA E 1,728 $ 1,953,912 S 175,852 1,369 1,942,365 S 155,389 CT G 1,750 S 1,930,818 S 193,082 DE 1,602 S 1,686,767 $ 211,120 FL 1,772 S 1,655,220 $ 228.927 GA 1,701 S 1,643,673 S 246,503 HI 1,660 S 1.632,126 S 169,617 ID 1,500 $ 1,620,579 S 149,847 IL 1,682 $ 1,609,032 S 186,154 IN 1,693 $ 1,597,485 $ 203,499 IA 1,102 $ 1,333,434 $ 220,613 KS 1,715 S 1,321,887 $ 237,496 KY 1,726 S 1,310.340 S 163,381 LA 1,737 S 1,610,340 $ 155,398 ME 1,288 S 1,910,340 S 193,093 MD 1,759 $ 2.210.340 $ 211,132 MA G 1,305 $ 2.510,000 $ 228.941 MI 1,781 $ 2,844.789 $ 246,518 MN 1,792 S 3,144,794 $ 189,627 1,108 S 1,777,548 S 149,856 MO D 1,687 $ 2,076,890 S 186,165 MT E 1,698 $ 2,376,232 S 203,511 NE 1,709 S 1,377,548 $ 220,627 NV 1,720 S 1,678,890 $ 237,511 NH 1,504 $1,976,232 S180,018 NJ 1,742 S 1,040,917 S 159,092 NM 1,753 $ 1,276,890 $ 197,711 NY 1,764 $ 1,576,232 $ 216,212 NC 1,388 S 1,888,748 $ 234,482 1,786 $ 1,566,789 $ 252,521 OH G 1,663 S 1,123,365 S 173,783 OK 1,674 S 1,488,748 S 153,550 OR 1,685 S 1,168,789 S 190,783 1,698 $ 1,999,998 $ 208,591 RI 1,707 S 1,838,670 $ 220,640 SC E 1,445 S 1,827,123 S 237,526 SD 1,729 $ 2.000,315 S 180,028 TN 1,740 $ 1,988,768 S 159,101 TX 1,387 S 1,415,878 $ 197,722 UT 1,762 S 1,826,998 $ 200,970 VT 1,773 $ 1,547,894 $ 217,854 VA 1.784 $ 1,942,580 S 252,535 WA 1,844 S 1,500,111 S 173,793 1,806 S 1,919,486 S 153,559 WI G 1,690 S 1,444,558 $ 190,794 WY 1,701 S 1,896,392 S 189,639 UW LOC W LOC W LUCU OWOCOWL USUWLOC W LOU Number of Employees 20 30 29 28 20 22 27 21 27 20 23 22 28 24 21 22 23 29 22 24 28 24 28 22 25 25 26 26 29 30 27 29 27 28 27 26 29 28 27 30 28 27 31 31 32 30 32 30 29 33 ND PA A B TI 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 48 47 48 49 50 51 52 Store Number 1 2 3 4 5 8 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 MS D E Year Branch Opened City State name 2010 Montgomery Alabama 2012 Juneau Alaska 2015 Phoenix Arizona 2014 Little Rock Arkansas 2011 Sacramento California 2011 Denver Colorado 2012 Hartford Connecticut 2013 Dover Delaware 2010 Tallahassee Florida 2013 Atlanta Georgia 2011 Honolulu Hawaii 2014 Boise Idaho 2015 Springfield Illinois 2012 Indianapolis Indiana 2013 Des Moines lowa 2015 Topeka Kansas 2015 Frankfort Kentucky 2010 Baton Rouge Louisiana 2011 Augusta Maine 2012 Annapolis Maryland 2010 Boston Massachusetts 2013 Lansing Michigan 2014 Saint Paul Minnesota 2014 Jackson Mississippi 2013 Jefferson City Missouri 2012 Helena Montana 2013 Lincoln Nebraska 2015 Carson City Nevada 2015 Concord New Hampshire 2010 Trenton New Jersey 2011 Santa Fe New Mexico 2012 Albany New York 2010 Raleigh North Carolina 2013 Bismarok North Dakota 2014 Columbus Ohio 2014 Oklahoma City Oklahoma 2013 Salem Oregon 2012 Harrisburg Pennsylvania 2013 Providence Rhode Island 2015 Columbia South Carolina 2015 Pierre South Dakota 2010 Nashville Tennessee 2011 Austin Texas 2012 Salt Lake City Utah 2010 Montpelier Vermont 2013 Richmond Virginia 2014 Olympia Washington 2014 Charleston West Virginia 2013 Madison Wisconsin 2012 Cheyenne Wyoming Store Manager Jackson Aiden Liam Lucas Noah Mason Ethan Caden Jacob Logan Jayden Elijah Jack Luke Michael Benjamin Alexander James Jay Caleb Connor William Carter Ryan Oliver Matthew Daniel Gabriel Henry Owen Grayson Dylan Landon Isaac Nicholas Wyatt Nathan Andrew Cameron Dominic Joshua Eli Sebastian Hunter Brayden David Samuel Evan Gavin Christian G Code for Total Abbrev Regional Items Sold iation Area (Qty Total Sales Net Profit AL 1,684 S 2,000,100 $ 300,015 AK 1,295 $ 1,988,553 $ 218,741 AZ 1,706 S 1.977,006 237,241 AR 1,455 $ 1,965,459 S 255,510 CA E 1,728 $ 1,953,912 S 175,852 1,369 1,942,365 S 155,389 CT G 1,750 S 1,930,818 S 193,082 DE 1,602 S 1,686,767 $ 211,120 FL 1,772 S 1,655,220 $ 228.927 GA 1,701 S 1,643,673 S 246,503 HI 1,660 S 1.632,126 S 169,617 ID 1,500 $ 1,620,579 S 149,847 IL 1,682 $ 1,609,032 S 186,154 IN 1,693 $ 1,597,485 $ 203,499 IA 1,102 $ 1,333,434 $ 220,613 KS 1,715 S 1,321,887 $ 237,496 KY 1,726 S 1,310.340 S 163,381 LA 1,737 S 1,610,340 $ 155,398 ME 1,288 S 1,910,340 S 193,093 MD 1,759 $ 2.210.340 $ 211,132 MA G 1,305 $ 2.510,000 $ 228.941 MI 1,781 $ 2,844.789 $ 246,518 MN 1,792 S 3,144,794 $ 189,627 1,108 S 1,777,548 S 149,856 MO D 1,687 $ 2,076,890 S 186,165 MT E 1,698 $ 2,376,232 S 203,511 NE 1,709 S 1,377,548 $ 220,627 NV 1,720 S 1,678,890 $ 237,511 NH 1,504 $1,976,232 S180,018 NJ 1,742 S 1,040,917 S 159,092 NM 1,753 $ 1,276,890 $ 197,711 NY 1,764 $ 1,576,232 $ 216,212 NC 1,388 S 1,888,748 $ 234,482 1,786 $ 1,566,789 $ 252,521 OH G 1,663 S 1,123,365 S 173,783 OK 1,674 S 1,488,748 S 153,550 OR 1,685 S 1,168,789 S 190,783 1,698 $ 1,999,998 $ 208,591 RI 1,707 S 1,838,670 $ 220,640 SC E 1,445 S 1,827,123 S 237,526 SD 1,729 $ 2.000,315 S 180,028 TN 1,740 $ 1,988,768 S 159,101 TX 1,387 S 1,415,878 $ 197,722 UT 1,762 S 1,826,998 $ 200,970 VT 1,773 $ 1,547,894 $ 217,854 VA 1.784 $ 1,942,580 S 252,535 WA 1,844 S 1,500,111 S 173,793 1,806 S 1,919,486 S 153,559 WI G 1,690 S 1,444,558 $ 190,794 WY 1,701 S 1,896,392 S 189,639 UW LOC W LOC W LUCU OWOCOWL USUWLOC W LOU Number of Employees 20 30 29 28 20 22 27 21 27 20 23 22 28 24 21 22 23 29 22 24 28 24 28 22 25 25 26 26 29 30 27 29 27 28 27 26 29 28 27 30 28 27 31 31 32 30 32 30 29 33 ND PA

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

Students also viewed these Accounting questions