Question: need help with part 2 on how to perform the comprehensive descriptive analysis and how to write the buisness report. 2. Display the data in

 need help with part 2 on how to perform the comprehensive

descriptive analysis and how to write the buisness report. 2. Display the

data in a way that makes it possible to compare wireless percent

for the three geographical regions. 3. Does the data reveal any differences

between regions? 4. What are the business implications, based on this data,

need help with part 2 on how to perform the comprehensive descriptive analysis and how to write the buisness report.

2. Display the data in a way that makes it possible to compare wireless percent for the three geographical regions. 3. Does the data reveal any differences between regions? 4. What are the business implications, based on this data, for a company in the middle of the country? What about those companies in the east? Part 11 College students and their parents are concerned about the cost of a college education. In the file "collegetuition.xlsx", the in- state and out-state tuition cost for all the US states is reported. Deliverable 1. Run a comprehensive descriptive analysis and write a business report from the perspective of a recruiter for a 4- year university. The report must include graphs, tables, and a by-region analysis. Note: Submit only one document with Part I and Part II, including all graphs, statistical analysis, and recommendations. 1,236 Q57 A c A o H NE 43 SOUTH In-state tuition Out-of-state 44 Alabama $10,530 $25,760 45 Arkansas $8,550 $21,000 46 Kentucky $10,300 $23,710 47 Louisiana $9,300 $23,280 48 Maryland $9,580 $22,060 49 Delaware $12,270 $30,970 50 Florida $6,360 $21,880 51 Georgia $8,570 $26,760 52 Mississippi $7,990 $19,060 53 North Carolina $7,380 $24,520 Oklahoma $8,460 $22,520 55 South Carolina $12,610 $31,350 56 Tennessee $9,790 $26,640 57 Texas $9,840 $26,210 58 Virginia $12,820 $33,270 59 West Virginia $7,890 $21,550 60 TOTALE $152,240 $400,540 NE 0 WE Sheet1 Calculation Mode Automatic Workbook Storsties D WEST In-state tuition Out-of-state Alaska $7,440 $22,840 Arizona $11,220 $29,750 California $9,680 $32,590 Colorado $10,800 $30,600 Hawaii $10,660 $31,090 Idaho $7,250 $22,580 Montana $6,910 $23,220 Nevada $7,270 $21,510 New Mexico $6,920 $20,060 Oregon $10,360 $30,300 $6,790 $20,730 Washington $9,480 $29,300 Wyoming $5,220 $16,830 TOTAL= $110,000 $331,400 Formatting vas Table Styles Number Tables H I J MIDWEST In-state tuition Out-of-state Illinois $13,620 $23,480 Indiana $9,360 $29,170 lowa $8,760 $26,040 Kansas $9,230 $23,910 Minnesota $11,300 $20,890 Missouri $8,870 $21,190 Nebraska $8,270 $20,310 North Dakota $8,200 $19,420 Ohio $10,510 $25,000 South Dakota $8,450 $12,480 Wisconsin $8,960 $22,930 Michigan $12,930 $36,840 TOTALE $118,460 $281,660 Insert Delete Format Clear - Sort & Find & Filter - Select Ide: Cells Editing L M N NORTHEAST In-state tuition out of state Connecticut $12,390 $29,020 Maine $9,970 $27,010 Massachusetts $12,730 $29,220 New Hampshire $16,070 $28,430 New Jersey $13,870 $26,600 New York $7,940 $19,500 Pennsylvania $14,440 $26,960 Rhode Island $12,230 $28,910 Vermont $16,040 $38,990 TOTALE $115,680 $254,640

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!