Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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, 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,640Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started