You need to make geofencing choices for advertising on social media in order to help the social media sales team increase bag revenues in 03 for the U.S. high school market. 7/7 (?) Help v Keep in mind that some of Frank's questions cannot be answered without purchasing data. However, the money you sp will be deducted from your marketing budget, so choose wisely. Buhi Historical High School Sales Data You can download this data for free ion Five-year High School Sales Revenue BALANCE $5,000 Last Year's Buhi Sales - High School These data are fictional. Any resemblance to persons or places is purely coincidental. Allocation Purchase McNelson DataPurchase McNelson Data School Data Tier Included Data Price $1,500.00 School Name School ID District ID # of Students Re-Download 2 School Name School ID District ID # of Students Graduation Rates Great School Rating $2,000.00 Purchase 3 School Name School ID District ID # of Students Graduation Rates Great School Rating $3,000.00 Purchase Open / Closed Campus Public / Private % Free or Reduced Lunch Drive to School Student Data Run Simulation Reading Assist3 School Name School ID District ID # of Students Graduation Rates Great School Rating $300000 Open 1 Closed Campus Public 1' Private '35 Free or Reduced Lunch Driveto School Student Data Tier Included Data Price 1 it of Students by Gender it of Students by Age it? of Students by Grade 32'000' 00 Pie-Download 2 # of Students by Gender it of Students by Age at of Students by Grade # of Students by Gender and Age 33-00000 3 # of Students by Gender it of Students by Age at of Students by Grade # of Students by Gender and Age 34-00000 # of Students by Gender and Grade Location Data Run Simulation Reading AssistO Analytics Report - Basic Data Integration Answer the 10 questions below worth a total of 100 points. In 2019, what percentage of total products purchased across all grades and genders were from zip code 43453? Enter a percentage value (ex. 100%, 100.00%, .01%, 10) What was the total 5 year revenue for Texas? Enter a decimal number (ex. 1, 1.0, 10.01, .1001) Run Simulation Reading AssistUsing 2019 sales data, Frank wants you to determine the school with the lowest percentage of Buhi products sold to 9th grade male students. For your analysis, compare the number of products sold to 9th grade male students at each individual school to the total number of products sold to all grades and genders at each individual school. Which school would you recommend {your answer should be the school's ID)? Enter a whole number (ex. 1.10.100. 1000) Using the McNelson data, how many states have 9 or less unique districts? Enter a whole number (ex. 1.10.100, 1000) Run Simulation Reading Assistlocation G) Help What is the total 5 year sales revenue for zip code 44955? :1 Enter a decimal number (ex. 1. 1.0.10.01, .1001) How many of the 346 schools listed in the McNelson data are located in Idaho? :1 Enter a whole number (ex. 1, 1 0, 100, 1000) Recommend Budget Allocation Recommend marketing budget allocations for the following high school customer segments based on your integrated data and the questions you answered. You can allocate your remaining budget to any number of customer segments. *If you purchased third-party data, the cost has been deducted from your budget below. For each persona type below, find the maximum each one spent on a single item and compare that with others to make a decision on how to allocate the budget to each persona. O Budget Allocation Arnas an Run Simulation Reading AssistFrank, the associate director of social media sales, will send '5 you a link to Buhi historical high school sales data and McNelson's U.S. school data. 2/7 O Budget Allocation Save $0.00 Allocation No changes. Remaining: $5,000.00 Personas Amount Female 14yo O SO $3000 Male 14yo O SO $3000 Female 15yo O SO $3000 Male 15yo O SO $3000 Female 16yo O SO $3000 Run Simulation Reading AssistFemale 16yo O SO $3000 Male 16yo O SO + $3000 Female 17yo O SO + $3000 Male 17yo O SO + $3000 Female 18yo O SO + $3000 Male 18yo O SO + $3000 Run Simulation Reading AssistAutoSave O Off) Syr-Buhi-High-School-Sales-Revenue v Search (Alt+Q) X File Home Insert Draw Page Layout Formulas Data Review View Help Foxit PDF Comments Share LO Calibri v 11 AA ab Wrap Text Insert General Ex AY O Delete Paste BIU~ E = Merge & Center $ ~ % " Conditional Format as Cell Sort & Find & Analyze Sensitivity Formatting * Table Styles Format Filter ~ Select v Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity A1 X V School ID A B C D E F G H I J K L M N 0 P Q R S T U V School IDIZip Male Female Neutral U Syr Total Sales Revenue Female 14 Male 14y Neutral 14 Female 15 Male 15yNeutral 1: Female 16 Male 16y( Neutral 1( Female 17 Male 17y Neutral 17 Female 18 Male 18y Neutral 18yo 5yr To 1310545 75731 0.48 0.52 $88,568 $15,604 $10,481 $20,809 $16,669 SO $6,827 $4,217 50 $5,836 $3,047 SO $3,748 $1,330 $O 1313074 73696 0.48 0.52 O $299,529 $31,583 $52,256 $37 $44,834 $84,723 $46 $14,888 $25,793 $0 $12,508 $15,801 so $8,200 $8,860 $0 1316833 26475 0.48 0.52 $53,765 $9,675 $6,202 $0 $12,894 $9,699 SO $4,332 $2,484 SO $3,698 $1,775 SO $2,226 $781 SO 1316885 19736 0.45 0.55 $45,927 $6,112 $6,565 so $8,706 $11,000 So $2,892 $2,768 So $2,649 $2,023 So $1,762 $1,450 So 1320519 27594 0.46 0.54 $44,236 $7,103 $4,929 So $10,422 $8,274 SO $3,477 $2,302 $3,413 $1,545 SO $1,778 $992 SO 7 1326896 67732 0.47 0.53 $29,870 $4,689 $3,558 so $6,614 $6,016 so $2,209 $1,825 so $1,833 $1,130 So $1,250 $746 So Co 1330553 87624 0.46 0.54 $42,143 $5,834 $5,407 $9,027 $8,907 SO $2,973 $2,521 $2,846 $1,677 SO $1,873 $1,079 SO 9 1340547 43285 0.53 0.47 O $117,959 $16,509 $16,711 so $22,598 $28,240 So $7,474 $7,341 SO $6,668 $5,260 So $4,312 $2,846 So 10 4115562 75861 0.46 0.54 $44,877 $5,893 $6,333 $0 $8,584 $10,598 so $2,825 $3,195 So $2,673 $1,939 so $1,517 $1,318 $0 11 4711205 84326 0.46 0.54 O $55,252 $7,979 $7,362 So $11,803 $11,663 so $3,968 $3,205 so $3,551 $2,189 so $2,136 $1,394 So 12 5310523 56178 0.39 0.6 $408,789 $63,060 $47,284 $65 $91,605 $81,232 SO $30,883 $24,243 so $27,186 $14,877 So $18,668 $9,607 SO 13 5325967 29876 0.51 0.49 $41,553 $5,226 $5,991 So $7,480 $10,484 So $2,479 $3,156 So $2,443 $1,958 So $1,516 $820 So 14 1310568 22322 0.51 0.49 $96,931 $14,514 $13,044 $9 $20,108 $21,387 So $6,569 $5,944 $0 $5,547 $3,966 SO $3,695 $2,136 15 5335924 22398 0.49 0.51 $26,785 $3,831 $4,006 $5,359 $6,100 so $1,779 $1,623 $1,526 $1,139 so $88 $541 so 16 7711597 99592 0.46 0.54 $37,387 $4,843 $5.908 SO $6,684 $9,390 SO $2,224 $2,604 $1,922 $1,753 SO $1,170 $888 SO 17 7721576 4465 0.53 0.47 O $41,637 $6,149 $5,681 $0 $8,153 $9,664 So $2,740 $2,804 so $2,269 $1,791 So $1,470 $915 So 18 1E+07 45679 0.48 0.52 $20,885 $2,849 $2,915 SO $4,104 $4,826 So $1,376 $1,239 So $1,255 $880 So $839 $604 $0 19 1E+07 84072 0.47 0.53 $57,728 $8,154 $7,722 $0 $11,470 $13,203 so $3,837 $3,718 $3,777 $2,443 so $2,160 $1,243 So 20 1E+07 75082 0.53 0.47 $182,421 $22,945 $27,470 $0 $34,827 $43,085 so $11,460 $12,214 so $10,738 $8,134 SO $6,843 $4,706 SO 21 1E+07 51718 0.38 0.62 $310,268 $47,601 $38,168 $49 $68,277 $63,771 $59 $22,529 $16,780 $0 $20,450 $11,953 $0 $13,204 $7,428 So 22 1E+07 83678 0.51 0.49 $21,350 $2,383 $3,498 So $3,440 $5,806 So $1,136 $1,767 $1,066 $1,082 SO $687 $490 SO 23 1.2E+07 54178 0.46 0.54 $37,786 $5,563 $4,795 so $7,754 $8,438 so $2,553 $2,352 so $2,464 $1,543 so $1,482 $841 so 5yr-Buhi-High-School-Sales-Reve + D Ready ? Accessibility: Unavailable + 89% O D1 5 ENG 2:12 PM Type here to search 199+ 24'C A O 2022-07-26AutoSave O Off) Syr-Buhi-High-School-Sales-Revenue v Search (Alt+Q) X File Home Insert Draw Page Layout Formulas Data Review View Help Foxit PDF Comments Share LO Calibri v 11 AA ab Wrap Text Insert General Ex AYO Delete Paste BIU~ E Merge & Center $ ~ % " Conditional Format as Cell Sort & Find & Analyze Sensitivity Formatting * Table Styles Format Filter ~ Select v Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity A1 X V School ID A B C D E F G H J K L M N P R S T U V 24 3.7E+07 19518 0.43 0.57 $18,716 $2,809 $2,402 So $4,171 $3,771 So $1,389 $945 So $1,315 $693 So $766 $455 $0 25 2339362 39816 0.52 0.48 $54,293 $8,071 $7,178 $0 $11,980 $11,139 So $4,003 $3,014 So $3,310 $2,058 So $2,137 $1,402 $0 26 9.4E+07 22070 0.46 0.54 $27,740 $3,996 $3,475 so $5,989 $5,845 so $1,970 $1,481 so $1,940 $1,102 so $1,202 $740 So 27 3.4E+07 98247 0.46 0.54 $48,299 $8,083 $5,593 SO $11,218 $9,130 SO $3,693 $2,622 so $3,223 $1,668 SO $2,336 $732 SO 28 6.58+07 78660 0.58 0.42 $688,841 $90,644 $100,600 $310 $129,635 $165,193 $219 $43,296 $49,529 $0 $40,516 $30,755 so $21,605 $16,379 SO 29 9.1E+07 92035 0.46 0.54 $88,073 $9,637 $14,828 $26 $13,830 $24,476 So $4,566 $6,651 $4,453 $4,514 SO $2,571 $2,489 SO 30 4.4E+07 46546 0.48 0.52 $42,900 $5,870 $5,707 so $8,268 $10,094 $2,728 $3,021 $2,371 $1,884 so $1,714 $1,244 So 31 2.1E+07 43769 0.46 0.54 $55,995 $8,620 $6.977 SO $11,989 $11,812 SO $3,983 $3,622 $3,437 $2,217 so $2,064 $1,275 SO 32 91 29909 0.45 0.55 O $62,394 $8,550 $9,256 $0 $12,313 $14,345 So $4,050 $4,197 so $3,743 $2,709 So $2,078 $1,153 So 33 7.9E+07 77201 0.56 0.44 $225,461 $28,201 $34,469 $20 $42,840 $53,803 $0 $14,255 $15,796 50 $13,342 $10,126 $0 $7,125 $5,460 $0 34 7.3E+07 29473 0.57 0.43 O $173,334 $18,668 $31,715 $0 $24,957 $50,618 so $8,380 $13,393 $6,909 $9,451 so $4,188 $5,056 So 35 7.7E+07 98649 0.46 0.54 $42,923 $6,401 $5,911 So $8,461 $9,950 so $2,811 $2,538 $2,490 $1,862 SO $1,524 $974 SO 36 7.3E+07 75388 0.44 0.56 $49,366 $7,276 $6,641 $0 $10,467 $10,488 So $3,525 $3,020 so $2,996 $1,945 So $2,190 $820 So 37 83360 0.52 0.48 $60,362 $8,913 $7,816 1 $12,281 $13,571 SO $4,030 $3,391 $0 $3,791 $2,522 So $2,240 $1,737 $0 38 100245 71154 0.43 0.56 $490,657 $72,856 $60,413 $306 $106,877 $100,473 $152 $35,403 $29,172 $0 $33,304 $18,538 so $19,485 $13,455 So 39 300339 36259 0.35 0.65 $185,864 $34,742 $16,303 $32 $49,919 $27,856 $15 $16,317 $8,141 so $15,193 $5,097 so $9,156 $3,068 SO 40 305438 22465 0.48 0.52 O $92,476 $13,861 $11,678 $0 $20,306 $19,013 So $6,810 $5,582 $0 $6,048 $3,521 So $3,834 $1,823 So 41 308961 48442 0.48 0.52 $47,188 $6,386 $7,336 SO $9,356 $10,765 So $3,149 $2,725 $2,806 $1,980 So $1,646 $1,039 $0 42 313342 73824 0.5 0.5 O $84,779 $11,886 $11,838 $12 $16,334 $20,185 so $5,425 $5,324 so $4,825 $3,763 so $3,132 $2,040 So 43 313364 14485 0.54 0.45 $57,765 $6,212 $9,578 $31 $9,254 $15,708 SO $3,043 $4,514 so $2,569 $2,898 SO $1,805 $2,115 SO 44 382016 45332 0.44 0.56 $52,478 $6,722 $7,755 $0 $10,049 $12,412 so $3,380 $3,713 so $3,215 $2,325 So $1,840 $1,067 So 45 500267 60947 0.53 0.47 $52,119 $6,402 $8,267 $40 $8,932 $13,551 SO $3,004 $3,446 So $2,487 $2,531 So $1,629 $1,782 SO 46 500354 77189 0.43 0.57 $766,972 $92,128 $128,012 $569 $126,891 $204,416 $491 $42,191 $56,366 $0 $38,254 $37,732 so $22,194 $17,523 so 5yr-Buhi-High-School-Sales-Reve + D Ready A? Accessibility: Unavailable + 89% Type here to search eco 199+ 24C A O DI ENG 2:12 PM 2022-07-26AutoSave O Off) Syr-Buhi-High-School-Sales-Revenue v Search (Alt+Q) X File Home Insert Draw Page Layout Formulas Data Review View Help Foxit PDF Comments Share v 11 AA Insert LO Calibri ab Wrap Text General ZAY Delete Paste BIU~ E Merge & Center $ ~ % " Conditional Format as Cell Sort & Find & Analyze Sensitivity Formatting * Table Styles Format Filter * Select v Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity A1 X V School ID A B C D E F G H J K L M N 0 P Q R S T U V 47 500310 29901 0.46 0.54 $42,712 $5,895 $5,915 $0 $8,628 $9,566 $0 $2,896 $2,864 $o $2,385 $1,774 so $1,778 $1,011 So 48 500398 91111 0.48 0.52 $882,597 $139,528 $109,472 $219 $189,540 $184,634 $195 $63,435 $53,790 SO $61,015 $34,366 $0 $32,074 $14,257 SO 49 500921 51362 0.53 0.47 $52,495 $6,204 $8,790 so $9,143 $13,461 So $3,036 $3,515 $2,928 $2,503 so $1,615 $1,300 So 50 502544 46647 0.5 0.5 $425,840 $67,452 $49,875 $91 $101,000 $79,374 $64 $33,110 $23,556 so $31,977 $14,913 SO $16,998 $7,383 SO 51 502505 28289 0.46 0.54 $40,543 $7,619 $3,331 So $10,788 $6,103 So $3,527 $1,746 So $3,370 $1,146 So $2,141 $772 SO 52 503914 43287 0.45 0.59 $43,054 $5,081 $6,848 $o $7,537 $10,958 $2,497 $3,304 $0 $2,393 $2,013 SO $1,388 $1,035 SO 53 503933 28765 0.48 0.52 $62,573 $10,385 $6,874 $22 $15,035 $11,218 so $4,991 $3,241 $0 $4,958 $2,092 so $2,531 $1,200 SO 54 504732 24674 0.48 0.52 $50,905 $6,592 $7,978 SO $9,570 $12,298 SO $3,179 $3,556 $2,862 $2,247 SO $1,68 $937 SO 55 504952 46573 0.48 0.52 $42,625 $4,993 $6,904 so $7,498 $10,859 so $2,461 $3,242 so $2,198 $1,978 So $1,495 $997 So 56 700418 81687 0.51 0.49 $88,897 $8,486 $17,769 $0 $12,384 $26,404 So $4,126 $6,634 So $3,383 $4,870 So $2,493 $2,348 $0 57 700434 39371 0.43 0.57 $450,583 $60,219 $63,509 $115 $87,116 $105,543 so $29,090 $32,300 50 $28,284 $19,282 so $16,812 $8,174 so 58 700430 75082 0.53 0.47 $54,639 $6,951 $8,221 $9,960 $13,673 SO $3,274 $3,458 $3,024 $2,517 SO $1,995 $1,565 SO 59 703504 45885 0.45 0.55 $182,421 $9,998 $6,887 $0 $15,166 $10,638 so $4,991 $2,781 SO $4,749 $2,001 So $2,740 $1,266 So o O 60 708453 91272 0.46 0.54 $56,885 $8,363 $8,175 $0 $11,348 $13,087 $3,779 $3,563 $0 $3,085 $2,443 So $2,024 $1,018 $0 61 900469 39893 0.41 0.59 0.01 $553,603 $76,520 $73,297 $716 $107,047 $129,891 $386 $35,496 $38,646 $0 $32,777 $24,026 so $20,413 $13,898 So 62 900441 43148 0.5 0.5 O $245,307 $37,343 $29,361 $0 $54,117 $50,067 $0 $17,738 $15,203 so $15,914 $9,320 SO $9,787 $6,458 SO 63 900479 71896 0.49 0.51 O $26,800 $3,856 $3,849 so $5,558 $5,885 So $1,856 $1,484 so $1,551 $1,110 So $1,064 $587 So 64 902281 28293 0.48 0.52 $40,701 $6,485 $5,043 SO $8,876 $8,410 SO $2,933 $2,344 $2,586 $1,573 $1,792 $658 $0 65 912369 43453 0.47 0.53 $22,020 $3,435 $2,737 so $5,108 $4,214 so $1,673 $1,065 so $1,512 $794 so $1,007 $474 so 66 922339 10844 0.45 0.54 $233,535 $41,451 $19,496 $273 $64,545 $32,596 $14 $21,639 $9,660 so $19,904 $6,122 so $13,248 $4,268 SO 67 932349 17383 0.49 0.51 $26,539 $3,402 $4,159 so $4,859 $6,539 so $1,634 $1,671 so $1,493 $1,226 So $874 $681 So 68 942292 37445 0.49 0.51 $94,543 $14,839 $11,182 so $21,119 $18,964 SO $7,032 $5,320 So $6,710 $3,573 So $4,020 $1,784 SO 69 1106925 28264 0.49 6.51 $70,087 $7,494 $11,624 $0 $10,675 $19,865 so $3,529 $5,552 so $3,471 $3,753 so $1,839 $2,286 so 5yr-Buhi-High-School-Sales-Reve + D Ready Accessibility: Unavailable -# + 89% Type here to search oe eto D1 2 ENG 2:12 PM 199+ 24'CA O 2022-07-26AutoSave O Off) Syr-Buhi-High-School-Sales-Revenue v Search (Alt+Q) X File Home Insert Draw Page Layout Formulas Data Review View Help Foxit PDF Comments Share LO Calibri v 11 AA ab Wrap Text General Insert Ex AYO Delete G Paste BIU~ E Merge & Center $ ~ % " Conditional Format as Cell Sort & Find & Analyze Sensitivity Formatting * Table Styles v Format Filter ~ Select v Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity A1 X V School ID A B C D E F G H J K L M N 0 P Q R S T U V 47 500310 29901 0.46 0.54 $42,712 $5,895 $5,915 $0 $8,628 $9,566 $0 $2,896 $2,864 $o $2,385 $1,774 so $1,778 $1,011 So 48 500398 91111 0.48 0.52 $882,597 $139,528 $109,472 $219 $189,540 $184,634 $195 $63,435 $53,790 SO $61,015 $34,366 $0 $32,074 $14,257 SO 49 500921 51362 0.53 0.47 $52,495 $6,204 $8,790 so $9,143 $13,461 So $3,036 $3,515 $2,928 $2,503 so $1,615 $1,300 So 50 502544 46647 0.5 0.5 $425,840 $67,452 $49,875 $91 $101,000 $79,374 $64 $33,110 $23,556 so $31,977 $14,913 SO $16,998 $7,383 SO 51 502505 28289 0.46 0.54 $40,543 $7,619 $3,331 So $10,788 $6,103 So $3,527 $1,746 So $3,370 $1,146 So $2,141 $772 SO 52 503914 43287 0.45 0.59 $43,054 $5,081 $6,848 $o $7,537 $10,958 $2,497 $3,304 $0 $2,393 $2,013 SO $1,388 $1,035 SO 53 503933 28765 0.48 0.52 $62,573 $10,385 $6,874 $22 $15,035 $11,218 so $4,991 $3,241 $0 $4,958 $2,092 so $2,531 $1,200 SO 54 504732 24674 0.48 0.52 $50,905 $6,592 $7,978 SO $9,570 $12,298 SO $3,179 $3,556 $2,862 $2,247 SO $1,68 $937 SO 55 504952 46573 0.48 0.52 $42,625 $4,993 $6,904 so $7,498 $10,859 so $2,461 $3,242 so $2,198 $1,978 So $1,495 $997 So 56 700418 81687 0.51 0.49 $88,897 $8,486 $17,769 $0 $12,384 $26,404 So $4,126 $6,634 So $3,383 $4,870 So $2,493 $2,348 $0 57 700434 39371 0.43 0.57 $450,583 $60,219 $63,509 $115 $87,116 $105,543 so $29,090 $32,300 50 $28,284 $19,282 so $16,812 $8,174 so 58 700430 75082 0.53 0.47 $54,639 $6,951 $8,221 $9,960 $13,673 SO $3,274 $3,458 $3,024 $2,517 SO $1,995 $1,565 SO 59 703504 45885 0.45 0.55 $182,421 $9,998 $6,887 $0 $15,166 $10,638 so $4,991 $2,781 SO $4,749 $2,001 So $2,740 $1,266 So o O 60 708453 91272 0.46 0.54 $56,885 $8,363 $8,175 $0 $11,348 $13,087 $3,779 $3,563 $0 $3,085 $2,443 So $2,024 $1,018 $0 61 900469 39893 0.41 0.59 0.01 $553,603 $76,520 $73,297 $716 $107,047 $129,891 $386 $35,496 $38,646 $0 $32,777 $24,026 so $20,413 $13,898 So 62 900441 43148 0.5 0.5 O $245,307 $37,343 $29,361 $0 $54,117 $50,067 $0 $17,738 $15,203 so $15,914 $9,320 SO $9,787 $6,458 SO 63 900479 71896 0.49 0.51 O $26,800 $3,856 $3,849 so $5,558 $5,885 So $1,856 $1,484 so $1,551 $1,110 So $1,064 $587 So 64 902281 28293 0.48 0.52 $40,701 $6,485 $5,043 SO $8,876 $8,410 SO $2,933 $2,344 $2,586 $1,573 $1,792 $658 $0 65 912369 43453 0.47 0.53 $22,020 $3,435 $2,737 so $5,108 $4,214 so $1,673 $1,065 so $1,512 $794 so $1,007 $474 so 66 922339 10844 0.45 0.54 $233,535 $41,451 $19,496 $273 $64,545 $32,596 $14 $21,639 $9,660 so $19,904 $6,122 so $13,248 $4,268 SO 67 932349 17383 0.49 0.51 $26,539 $3,402 $4,159 so $4,859 $6,539 so $1,634 $1,671 so $1,493 $1,226 So $874 $681 So 68 942292 37445 0.49 0.51 $94,543 $14,839 $11,182 so $21,119 $18,964 SO $7,032 $5,320 So $6,710 $3,573 So $4,020 $1,784 SO 69 1106925 28264 0.49 6.51 $70,087 $7,494 $11,624 $0 $10,675 $19,865 so $3,529 $5,552 so $3,471 $3,753 so $1,839 $2,286 so 5yr-Buhi-High-School-Sales-Reve + D Ready Accessibility: Unavailable + 89% Type here to search oe eto D1 2 ENG 2:13 PM 199+ 24'CA O 2022-07-26AutoSave O Off) Syr-Buhi-High-School-Sales-Revenue v Search (Alt+Q) X File Home Insert Draw Page Layout Formulas Data Review View Help Foxit PDF Comments Share LO Calibri AA ab Wrap Text General Insert v 11 Ex AYO Delete GI Paste BIU~ E Merge & Center $ ~ % " Conditional Format as Cell Sort & Find & Analyze Sensitivity Formatting * Table Styles Format Filter ~ Select v Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity A1 X V School ID A B C D E F G H J K L M N P Q R S T U V 70 1209197 71817 0.53 0.47 O $49,392 $6,733 $7,228 So $9,613 $11,548 So $3,185 $3,325 So $2,804 $2,161 So $1,661 $1,135 So 71 1300602 48689 0.44 0.56 $78,655 $11,117 $10,635 $43 $16,346 $17,201 So $5,465 $5,250 So $4,739 $3,225 SO $2,843 $1,738 SO o O 72 1313155 48840 0.49 0.51 $64,755 $8,025 $10,014 $36 $11,532 $16,515 so $3,764 $4,459 so $3,768 $3,067 so $2,214 $1,314 So 73 5325880 78237 0.5 0.49 $79,251 $ $11,407 $10,278 $57 $16,517 $17,323 SO $5,506 $4,703 SO $5,396 $3,176 so $3,237 $1,583 SO 74 1301529 44991 0.5 0.5 $56,945 $7,404 $8,241 $31 $10,774 $13,607 SO $3,530 $4,040 so $3,251 $2,566 so $2,021 $1,443 SO 75 1303095 13282 0.46 0.53 $348,316 $58,927 $36,879 $227 $83,120 $62,941 So $28,028 $15,930 $26,027 $11,477 $0 $16,755 $7,727 SO 76 1300554 46720 0.54 0.46 $53,975 $7,150 $7,658 so $9,876 $13,394 so $3,240 $4,082 so $2,876 $2,517 so $1,761 $1,422 So 77 1323122 87153 0.47 0.53 $225,877 $29,417 $31,480 $58 $43,143 $53,326 so $14,425 $15,691 so $14,090 $9,726 SO $8,074 $6,377 SO 78 1303828 28852 0.46 0.54 O $98,320 $15,269 $12,299 $0 $20,974 $20,701 so $7,036 $5,647 So $5,909 $3,901 So $3,803 $2,782 So 79 1303977 29127 0.47 0.53 $34,367 $4,765 $4,552 $7,107 $7,598 so $2,341 $2,040 So $2,235 $1,427 So $1,472 $833 $0 80 1304432 18273 0.46 0.54 $54,766 $8,365 $7,019 SO $12,387 $10,762 so $4,078 $2,761 so $3,847 $1,993 so $2,249 $1,303 So 81 1304417 55121 0.38 0.62 $724,684 $111,129 $87,609 $0 $162,308 $143,795 $0 $53,769 $42,692 so $53,165 $26,675 so $32,632 $10,911 SO 82 1305933 81774 0.49 0.51 $88,809 $11,095 $12,525 $14 $15,961 $22,281 SO $5,395 $6,078 so $5,183 $4,073 so $3,276 $2,912 So 83 1307133 45982 0.5 0.5 o o O $398,059 $55,942 $58,976 $110 $79,456 $91,097 $64 $25,939 $23,816 $0 $23,591 $16,713 so $8,639 84 1307136 73680 0.51 D.49 $85,056 $13,324 $10,877 $27 $17,829 $18,344 so $5,961 $4,834 $0 $5,175 $3,402 so $3,219 $2,032 So 85 1500175 84651 0.47 0.53 $83,159 $12,675 $10,795 $53 $18,256 $17,091 SO $6,066 $4,528 $5,672 $3,190 SO $3,231 $1,537 SO 86 1500192 43147 0.47 0.53 $42,928 $6,897 $5,561 So $9,229 $8,991 So $3,039 $2,251 So $2,884 $1,666 So $1,524 $885 So 87 1500113 72412 0.47 0.53 $47,294 $5,391 $7,752 So $8,055 $12,313 so $2,703 $3,693 $0 $2,263 $2,287 So $1,534 $1,303 $0 88 1500196 55317 0.49 0.51 $20,154 $2,423 $3,244 so $3,318 $5,446 so $1,104 $1,669 $o $947 $995 $556 $451 So 9 1501925 48558 0.51 0.49 $40,554 $4,925 $6,443 SO $7,125 $10,416 SO $2,341 $3,085 $2,163 $1,966 SO $1,302 $787 SO 90 1501866 74158 0.52 0.48 $101,729 $14,261 $14,151 $22 $20,682 $22,687 so $6,898 $6,266 So $5,889 $4,154 so $4,236 $2,458 So 91 1511894 67335 0.52 0.48 $261,886 $42,483 $29,727 $59,663 $50,838 $19,756 $14,110 $0 $17,847 $9,430 so $11,841 $6,008 SO 92 1501944 54336 0.45 0.55 0 $573,917 $97,889 $65,852 $393 $138,822 $102,857 $198 $46,589 $26,122 $0 $38,530 $19,141 $0 $27,764 $9,477 so Syr-Buhi-High-School-Sales-Reve + D Ready Accessibility: Unavailable + 89% Type here to search eco O 24'C A O DI ENG 2:13 PM 199+ 2022-07-26AutoSave O Off) Syr-Buhi-High-School-Sales-Revenue v Search (Alt+Q) X File Home Insert Draw Page Layout Formulas Data Review View Help Foxit PDF Comments Share Insert LO Calibri v 11 AA ab Wrap Text General Z X AY O Delete Paste BIU~ E Merge & Center $ ~ % " Conditional Format as Cell Sort & Find & Analyze Sensitivity Formatting * Table Styles Format Filter ~ Select v Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity A1 X V School ID A B C D E F G H J K L M N 0 P Q R S T U V 93 1501878 73142 0.5 0.5 $27,512 $5,116 $2,647 SO $7,056 $4,422 $0 $2,350 $1,318 SO $2,094 $817 so $1,253 $438 $0 94 1502762 45134 0.42 0.58 $480,180 $60,322 $76,332 $284 $86,446 $121,126 $157 $28,401 $30,720 $0 $27,945 $22,726 So $15,892 $9,641 95 1505252 43225 0.38 0.62 $239,202 $32,318 $34,127 $0 $45,616 $57,260 $0 $15,003 $16,164 $0 $14,504 $10,465 so $9,409 $4,336 So 96 1509670 79397 0.5 0.5 $98,645 $16,044 $10,172 $76 $23,607 $17,925 $44 $7,845 $5,345 SO $6,979 $3,335 SO $4,817 $2,408 SO 97 1700148 98790 0.52 0.48 $60,102 $8,592 $7,880 so $12,530 $13,148 So $4,198 $3,496 SO $3,814 $2,466 So $2,387 $1,589 SO 98 1705187 71840 0.49 0.5 $80,998 $13,047 $10,038 $15 $17,835 $16,394 SO $5,951 $4,485 $0 $5,159 $2,998 So $3,193 $1,864 SO 99 1702079 44775 0.35 0.65 $202,572 $33,491 $21,342 $0 $46,062 $39,474 so $15,400 $11,861 So $14,794 $7,336 so $7,602 $5,209 So 100 1705174 44955 0.49 0.5 $88,213 $11,249 $13,984 $42 $16,188 $21,795 SO $5,417 $5,482 so $4,573 $4,027 SO $3,157 $2,248 SO 101 1710898 45313 0.53 0.47 $28,928 $4,063 $3,951 so $5,459 $6,962 so $1,822 $2,123 so $1,673 $1,302 So $1,027 $546 So 102 2100709 45766 0.48 0.52 $57,132 $8,800 $7,231 $0 $12,793 $11,358 So $4,307 $3,356 So $3,984 $2,111 $2,332 $859 $0 103 2100675 46139 0.55 0.45 $235,012 $39,078 $25,022 $147 $56,288 $42,819 $76 $18,505 $11,891 SO $16,989 $8,049 so $11,020 $5,024 so 104 2106375 2866 0.5 0.5 $78,793 $10,977 $10,937 $40 $16,316 $17,230 SO $5,379 $4,888 50 $4,974 $3,182 so $2,693 $2,128 SO 105 2106918 67931 0.43 0.57 $66,053 $7,485 $11,046 So $10,554 $18,107 SO $3,509 $4,898 So $3,281 $3,416 So $1,982 $1,774 So 106 2107228 24328 0.44 0.56 $45,974 $8,020 $4,819 $0 $11,471 $7,864 SO $3,858 $2,413 $0 $3,241 $1,463 So $1,896 $929 $0 107 2107238 52162 0.44 0.56 $85,485 $12,565 $10,669 $0 $18,134 $18,284 so $6,046 $5,513 so $5,306 $3,416 so $3,153 $2,400 So 108 2109206 48282 0.41 0.59 $271,555 $46,914 $30,020 $72 $64,536 $49,707 so $21,591 $13,232 so $20,870 $9,253 so $11,279 $3,992 SO 109 2109197 74557 0.49 0.51 O $58,487 $10,684 $6,531 $0 $14,064 $10,566 so $4,615 $2,696 so $4,125 $1,935 So $2,422 $849 So 110 2109132 95968 0.49 0.51 $83,652 $11,149 $12,655 $15,832 $19,949 So $5,242 $5,128 $4,419 $3,661 $0 $3,115 $2,502 111 2109226 54938 0.49 0.51 O $48,815 $7,171 $6,386 $20 $10,683 $10,081 so $3,540 $2,877 $o $2,974 $1,885 so $2,102 $1,072 So 112 2304575 83864 0.43 0.57 $46,090 $6,554 $5,972 SO $9,222 $10,463 SO $3,066 $3,113 so $2,932 $1,924 SO $1,562 $1,279 SO 113 2304582 50282 0.52 0.48 $146,471 $23,397 $18,569 $0 $31,167 $31,421 so $10,250 $8,732 so $8,560 $5,781 so $6,156 $2,438 So 114 2305576 72590 0.49 0.51 $32,194 $4,702 $4,159 SO $7,204 $6,422 SO $2,389 $1,705 SO $2,248 $1,183 So $1,458 $724 SO 115 2307648 22016 0.44 0.55 $37,190 $5,762 $4,428 $32 $8,354 $7,409 so $2,761 $2,108 so $2,669 $1,356 so $1,545 $728 so 5yr-Buhi-High-School-Sales-Reve + D Ready Accessibility: Unavailable + 89% Type here to search 24C A DI ENG 2:13 PM 199+ 2022-07-26AutoSave O Off) Syr-Buhi-High-School-Sales-Revenue v Search (Alt+Q) X File Home Insert Draw Page Layout Formulas Data Review View Help Foxit PDF Comments Share AA ab Wrap Text General Insert LO Calibri v 11 Ex AYO Delete Paste BIU~ E Merge & Center $ ~ % " Conditional Format as Cell Sort & Find & Analyze Sensitivity Formatting * Table Styles Format Filter ~ Select v Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity A1 X V School ID A B C D E F G H J K L M N P Q R S T U V 116 2307616 79560 0.43 0.57 O $47,284 $7,151 $6,225 So $9,739 $10,398 So $3,274 $3,046 So $2,859 $1,937 So $1,815 $840 $0 117 2311135 45774 0.45 0.55 $86,234 $12,741 $11,950 $0 $17,306 $19,595 so $5,678 $5,158 So $5,062 $3,676 SO $3,434 $1,633 $0 118 2500790 49961 0.47 0.53 $37,831 $6,397 $4,218 so $9,035 $6,877 so $2,997 $1,999 $o $2,635 $1,281 So $1,594 $798 So 119 2500798 6732 0.53 0.47 $58,207 $7,062 $9,499 SO $9,511 $15,737 SO $3,189 $4,420 so $2,699 $2,920 So $1,682 $1,490 SO 120 2501684 83737 0.47 0.53 $104,759 $17,650 $12,108 $0 $25,483 $18,575 so $8,457 $4,655 so $7,870 $3,431 So $4,356 $2,173 SO 121 2502472 98192 0.53 0.47 $18,873 $1,981 $3,273 $0 $3,023 $5,109 SO $1,020 $1,533 $0 $884 $948 SO $627 $476 SO 122 2503897 7630 0.49 0.51 $31,505 $4,193 $4,672 so $6,136 $7,388 so $2,020 $1,952 $1,692 $1,371 $1,179 $902 So 123 2503882 79144 0.44 0.56 $96,364 $15,187 $11,772 so $20,129 $20,981 SO $6,687 $5,477 $6,567 $3,919 SO $3,751 $1,894 SO 124 2504915 76518 0.45 0.55 O $177,812 $25,301 $22,856 $126 $36,705 $39,092 so $12,066 $10,975 $0 $11,765 $7,300 So $7,479 $3,992 So 125 2505890 63345 0.54 0.46 $98,076 $13,167 $14,509 $53 5 $24,526 so $5,887 $6,691 $0 $4,875 $4,475 $0 $3,066 $3,154 $0 126 2700811 77920 0.43 0.57 $41,978 $6,356 $5,442 so $8,988 $8,831 so $2,983 $2,250 $o $2,780 $1,641 so $1,763 $944 So 127 2700761 64550 0.43 0.57 $41,570 $6,924 $4,381 SO $10,277 $7,214 SO $3,412 $1,912 SO $3,160 $1,358 SO $2,033 $898 SO 128 2707990 8343 0.49 0.51 $26,886 $3,765 $3,610 so $5,684 $5,736 so $1,898 $1,556 so $1,761 $1,047 So $1,133 $697 So 129 2707941 59873 0.47 0.53 $62,831 $8,180 $8,897 $0 $12,488 $14,395 SO $4,130 $4,074 $0 $3,648 $2,627 So $2,503 $1,889 130 2901856 98125 0.47 0.53 $60,406 $9,260 $7,914 so $12,497 $13,261 so $4,192 $3,962 $3,435 $2,468 So $2,075 $1,344 So 131 2900873 50265 0.52 0.48 $57,293 $6,967 $8,392 So $9,913 $14,974 SO $3,304 $4,595 so $2,907 $2,744 so $1,996 $1,501 SO 132 2900804 48263 0.5 0.5 O $32,076 $4,331 $4,657 so $6,144 $7,631 So $2,043 $2,200 so $1,816 $1,423 So $1,186 $646 So 133 2900851 4995 0.49 0.51 $77,382 $11,157 $10,860 $23 $15,650 $17,444 So $5,189 $5,021 $4,364 $3,217 $2,861 $1,571 $0 134 2900805 34263 0.5 0.5 O $55,469 $8,912 $6,402 $22 $12,876 $10,471 so $4,245 $2,755 so $4,123 $1,950 so $2,376 $1,311 so 135 2900874 74904 0.44 0.56 $52,975 $7,559 $6,645 so $11,871 $10,518 SO $3,995 $2,738 so $3,882 $1,978 SO $2,402 $1,387 SO 136 2900818 98822 0.47 0.53 $41,032 $7,261 $4,291 $0 $10,549 $6,627 so $3,492 $1,860 so $3,199 $1,219 so $1,846 $687 So 137 2900880 46995 0.52 0.48 $30,241 $3,601 $4,684 So $5,350 $7,697 so $1,792 $2,183 So $1,685 $1,407 So $1,103 $739 SO 138 2900835 46303 0.33 0.67 $217,354 $34,508 $23,688 $0 $52,549 $38,791 $0 $17,585 $10,277 $0 $17,332 $7,271 $0 $10,293 $5,060 so 5yr-Buhi-High-School-Sales-Reve + D Ready Accessibility: Unavailable + 89% Type here to search O DI ENG 2:14 PM 199+ 24'C A 2022-07-26AutoSave O Off) Syr-Buhi-High-School-Sales-Revenue v Search (Alt+Q) X File Home Insert Draw Page Layout Formulas Data Review View Help Foxit PDF Comments Share Calibri AA ab Wrap Text Insert LO v 11 General Ex AYO Delete Paste BIU ~ E Merge & Center $ ~ % " Conditional Format as Cell Sort & Find & Analyze Sensitivity Formatting * Table Styles Format Filter * Select v Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity A1 X V School ID A B C D E F G H J K L M N O P Q R S T U V 119 2500798 6732 0.53 0.47 $58,207 $7,062 $9,499 So $9,511 $15,737 So $3,189 $4,420 So $2,699 $2,920 So $1,682 $1,490 $0 120 2501684 83737 0.47 0.53 $104,759 $17,650 $12,108 $25,483 $18,575 so $8,457 $4,655 So $7,870 $3,431 So $4,356 $2,173 121 2502472 98192 0.53 0.47 $18,873 $1,981 $3,273 so $3,023 $5,109 so $1,020 $1,533 $884 $948 So $627 $476 So 122 2503897 7630 0.49 0.51 $31,505 $4,193 $4,672 SO $6,136 $7,388 SO $2,020 $1,952 SO $1,692 $1,371 SO $1,179 $902 SO 123 2503882 79144 0.44 0.56 O $96,364 $15,187 $11,772 $0 $20,129 $20,981 so $6,687 $5,477 so $6,567 $3,919 So $3,751 $1,894 SO 124 2504915 76518 0.45 0.55 $177,812 $25,301 $22,856 $126 $36,705 $39,092 So $12,066 $10,975 so $11,765 $7,300 So $7,479 $3,992 SO 125 2505890 63345 0.54 0.46 $98,076 $13,167 $14,509 $53 $17,609 $24,526 so $5,887 $6,691 so $4,875 $4,475 so $3,066 $3,154 So 126 2700811 77920 0.43 0.57 $41,978 $6,356 $5,442 SO $8,988 $8,831 SO $2,983 $2,250 SO $2,780 $1,641 So $1,763 $944 SO 127 2700761 64550 0.43 0.57 O $41,570 $6,924 $4,381 So $10,277 $7,214 so $3,412 $1,912 SO $3,160 $1,358 So $2,033 $898 SO 128 2707990 8345 0.49 0.51 $26,886 $3,765 $3,610 $0 $5,684 $5,736 $0 $1,898 $1,556 $0 $1,761 $1,047 $0 $1,133 $697 $0 129 2707941 59873 0.47 0.53 $62,831 $8,180 $8,897 So $12,488 $14,395 So $4,130 $4,074 so $3,648 $2,627 so $2,503 $1,889 so 130 2901856 98125 0.47 0.53 $60,406 $9,260 $7,914 $12,497 $13,261 So $4,192 $3,962 SO $3,435 $2,468 SO $2,075 $1,344 SO 131 2900873 50265 0.52 0.48 $57,293 $6,967 $8,392 so $9,913 $14,974 so $3,304 $4,595 So $2,907 $2,744 So $1,996 $1,501 So 132 2900804 48263 0.5 0.5 $32,076 $4,331 $4,657 SO $6,144 $7,631 So $2,043 $2,200 $0 $1,816 $1,423 So $1,186 $646 133 2900851 4995 0.49 0.51 $77,382 $11,157 $10,860 $23 $15,650 $17,444 so $5,189 $5,021 so $4,364 $3,217 So $2,861 $1,571 so 134 2900805 34263 0.5 0.5 $55,469 $8,912 $6,402 $22 $12,876 $10,471 SO $4,245 $2,755 $4,123 $1,950 SO $2,376 $1,311 SO 135 2900874 74904 0.44 0.56 O $52,975 $7,559 $6,645 $0 $11,871 $10,518 so $3,995 $2,738 SO $3,882 $1,978 so $2,402 $1,387 So 136 2900818 98822 0.47 0.53 $41,032 $7,261 $4,291 $0 $10,549 $6,627 So $3,492 $1,860 So $3,199 $1,219 So $1,846 $687 $0 137 2900880 46995 0.52 0.48 $30,241 $3,601 $4,684 so $5,350 $7,697 so $1,792 $2,183 $0 $1,685 $1,407 so $1,103 $739 So 138 2900835 46303 0.33 0.67 $217,354 $34,508 $23,688 $0 $52,549 $38,791 SO $17,585 $10,277 so $17,332 $7,271 so $10,293 $5,060 SO 139 3101326 46343 0.44 D.56 $21,353 $3,331 $2,771 so $4,713 $4,326 so $1,588 $1,115 $0 $1,403 $788 so $905 $412 so 140 141 Syr-Buhi-High-School-Sales-Reve + Ready ? Accessibility: Unavailable + 89% X C1 5 ENG 2:14 PM Type here to search oe 199+ 24'CA O 2022-07-26You can use the Buhi data as a reference to complete your task. However, the McNelson data contains multiple fields NCE 00 of data. Use the $10,000 marketing budget to purchase specific data from McNelson that will best help you answer Frank's questions. 3/7X AutoSave O Off) 2019_Sales_Data_By_School_Grade Search (Alt+Q) Foxit PDF Comments Share Home Insert Draw Page Layout Review Help File Formulas Data Insert E AY O LO Calibri v 11 VA A ab Wrap Text General Delete Conditional Format as Cell Sort & Find & Analyze Sensitivity Paste BIU ~ E Merge & Center $ ~ % " Formatting * Table Styles Format Filter ~ Select v Data Styles Cells Editing Analysis Sensitivity Clipboard Font Alignment Number X V D E F G H K L M N O P A B C School ID Buhi Products Purchased by Males in 9th Buhi Products Purchased by Females in 9th Buhi Produ Buhi Produ Buhi Produ Buhi Produ Buhi Produ Buhi Products Purchased by Females in 12th 1 Zip 141! 106 55 94 42 75731 1310545 85 82 57 420 549 378 412 238 259 365 307 AWN 73696 1313074 72 14 26475 1316833 64 137 64 80 38 28 62 29 35 43 39 19736 1316885 65 72 36 58 65 43 52 26 16 18 35 27594 1320519 27 37 21 28 9 18 26 10 67732 1326896 74 42 62 18 28 53 38 87624 1330553 58 120 90 133 45 164 17 43285 1340547 187 55 75861 4115562 59 84 34 59 18 21 41 11 10 63 60 40 54 31 48 41 40 11 84326 4711205 400 834 400 592 200 417 430 353 12 56178 5310523 20 13 29876 5325967 57 33 42 53 21 29 72 89 109 93 82 62 44 99 60 14 22322 1310568 43 55 33 44 26 26 31 14 15 22398 5335924 39 72 32 45 25 16 44 29 16 99592 7711597 4465 7721576 48 60 33 38 17 29 46 2 17 29 39 22 22 12 9 16 15 18 45679 10010044 80 42 68 23 48 64 6 19 84072 10020035 49 212 67 235 33 196 23 143 20 75082 10030098 82 337 535 187 489 112 214 302 292 21 51718 10040029 12 6 22 83678 10172523 27 22 18 14 10 2019_Sales_Data_By_School_Grade + + 95% Ready ? Accessibility: Unavailable 2:17 PM 799 0 3 X 24'C A O DI ENG Type here to search 2022-07-26X AutoSave O Off) 2019_Sales_Data_By_School_Grade Search (Alt+Q) Foxit PDF Comments Share Home Insert Draw Page Layout Review Help File Formulas Data Insert E AY O LO Calibri v 11 VA A ab Wrap Text General Delete Conditional Format as Cell Sort & Find & Analyze Sensitivity Paste BIU ~ E Merge & Center $ ~ % " Formatting * Table Styles Format Filter ~ Select v Data Styles Cells Editing Analysis Sensitivity Clipboard Font Alignment Number X V D E F G H K L M N O P A B C School ID Buhi Products Purchased by Males in 9th Buhi Products Purchased by Females in 9th Buhi Produ Buhi Produ Buhi Produ Buhi Produ Buhi Produ Buhi Products Purchased by Females in 12th 1 Zip 141! 106 55 94 42 75731 1310545 85 82 57 420 549 378 412 238 259 365 307 AWN 73696 1313074 72 14 26475 1316833 64 137 64 80 38 28 62 29 35 43 39 19736 1316885 65 72 36 58 65 43 52 26 16 18 35 27594 1320519 27 37 21 28 9 18 26 10 67732 1326896 74 42 62 18 28 53 38 87624 1330553 58 120 90 133 45 164 17 43285 1340547 187 55 75861 4115562 59 84 34 59 18 21 41 11 10 63 60 40 54 31 48 41 40 11 84326 4711205 400 834 400 592 200 417 430 353 12 56178 5310523 20 13 29876 5325967 57 33 42 53 21 29 72 89 109 93 82 62 44 99 60 14 22322 1310568 43 55 33 44 26 26 31 14 15 22398 5335924 39 72 32 45 25 16 44 29 16 99592 7711597 4465 7721576 48 60 33 38 17 29 46 2 17 29 39 22 22 12 9 16 15 18 45679 10010044 80 42 68 23 48 64 6 19 84072 10020035 49 212 67 235 33 196 23 143 20 75082 10030098 82 337 535 187 489 112 214 302 292 21 51718 10040029 12 6 22 83678 10172523 27 22 18 14 10 2019_Sales_Data_By_School_Grade + + 95% Ready ? Accessibility: Unavailable 2:17 PM 799 0 3 X 24'C A O DI ENG Type here to search 2022-07-26X AutoSave O Off) 2019_Sales_Data_By_School_Grade Search (Alt+Q) Comments Share File Home Insert Draw Page Layout Formulas Data Review Help Foxit PDF Insert Calibri General 2x AY ab Wrap Text LO v 11 VA A Delete Conditional Format as Cell Sort & Find & Analyze Sensitivity Paste BIU~ E Merge & Center $ ~ % " Formatting Table Styles Format Filter * Select v Data Styles Cells Editing Analysis Sensitivity Clipboard Font Alignment Number X V E F G H K L M N O P A B C D 23 54178 12310086 58 96 29 56 29 17 30 3 23 29 12 22 6 17 19 13 24 19518 36707828 55 44 24 25 39816 2339362 92 100 53 29 69 56 33 52 14 21 39 13 26 22070 94085899 34 83 27 49 22 29 39 3 27 98247 33613223 51 1,528 1,089 659 508 289 618 160 28 78660 64797993 1,415 96 165 86 105 38 86 100 20 29 92035 90813203 40 63 30 44 18 32 63 24 30 46546 44299948 47 64 18 36 38 18 31 43769 21166682 65 82 66 91 49 81 22 27 33 9 32 29909 91 289 288 258 280 175 168 313 64 33 77201 78681960 390 402 249 305 217 80 230 17 34 29473 72802090 25 35 98649 77389864 47 49 31 51 15 21 33 46 77 34 30 40 30 36 75388 72764766 51 79 51 83 47 63 31 20 69 16 37 83360 69 1 38 71154 100245 196 723 285 482 198 402 261 171 527 191 439 109 125 213 166 39 36259 300339 87 124 72 79 46 51 86 65 40 22465 305438 83 93 61 63 34 51 35 27 41 48442 308961 73824 313342 95 116 82 103 49 66 103 49 42 81 61 52 87 49 26 80 45 43 14485 313364 84 136 46 87 23 60 81 20 44 45332 387016 2019_Sales_Data_By_School_Grade (+) + 95% Ready A? Accessibility: Unavailable 2:17 PM 799 0 0 X 24'C A O DI ENG Type here to search 2022-07-26X 2019_Sales_Data_By_School_Grade Search (Alt+Q) AutoSave O Off) Comments Share Foxit PDF File Home Insert Draw Page Layout Formulas Data Review Help Insert Ex AYO General LO Calibri v 11 VA A ab Wrap Text Delete GI Conditional Format as Cell Sort & Find & Analyze Sensitivity Paste BIU ~ E Merge & Center $ ~ % " Formatting * Table Styles Format Filter * Select v Data Number Styles Cells Editing Analysis Sensitivity Alignment Clipboard Font X V O P D E F G H K L M N A B C 38 40 24 32 57 20 45 60947 500267 66 71 723 643 1,000 500 1,020 144 77189 500354 1,929 294 46 35 80 29 22 51 47 29901 500310 56 98 971 2,130 1,045 1,246 373 522 1,346 122 48 91111 500398 82 49 50 25 35 53 8 49 51362 500921 70 335 431 193 50 46647 502544 526 574 414 494 223 66 39 43 18 16 29 29 51 28289 502505 45 79 76 53 67 30 26 42 49 52 43287 503914 61 38 56 17 24 40 24 53 28765 503933 60 72 52 54 18 50 50 26 54 24674 504732 67 77 34 46573 504952 132 64 64 55 136 78 81 483 672 425 553 219 316 339 436 56 81687 700418 61 36 53 28 16 66 31 57 39371 700434 50 58 72 43 56 28 49 39 31 58 75082 700430 68 79 37 55 34 35 33 29 59 45885 703504 1,471 633 943 316 528 588 832 60 91272 708453 1,003 210 360 83 39893 900469 428 583 243 291 127 61 22 47 22 21 16 9 22 9 62 43148 900441 40 61 29 57 16 20 61 23 63 71896 900479 9 13 10 64 28293 902281 23 33 19 25 13 395 272 294 93 192 208 250 65 43453 912369 366 36 44 25 27 11 18 12 66 10844 972339 2019_Sales_Data_By_School_Grade (+ + 95% Ready A? Accessibility: Unavailable 2:17 PM 799- 0 3 O X 24 CA O DI ENG 2022-07-26 Type here to searchX AutoSave O Off) 2019_Sales_Data_By_School_Grade Search (Alt+Q) Comments Share File Home Insert Draw Page Layout Formulas Data Review Help Foxit PDF Insert IM AY O Calibri v 11 VA A ab Wrap Text General LO Delete Conditional Format as Cell Sort & Find & Analyze Sensitivity Paste BIU~ E Merge & Center $ ~ % " Formatting * Table Styles Format Filter ~ Select v Data Styles Cells Editing Analysis Sensitivity Clipboard Font Alignment Number X V F G H K L M N O P D E A B C 71 153 65 97 57 41 93 5 67 17383 932349 72 81 34 57 98 53 68 37445 942292 87 112 104 53 55 26 20 55 7 69 28264 1106925 72 71817 1209197 71 207 82 101 28 43 104 13 70 88 144 71 83 55 51 62 10 71 48689 1300602 87 107 56 62 43 38 58 32 72 48840 1313155 106 55 41 34 51 7 73 5325880 59 57 44991 1301529 365 645 294 548 182 322 563 99 74 81 52 53 34 24 49 15 75 13282 1303095 66 46720 1300554 350 551 298 536 129 208 522 196 76 102 174 64 107 64 81 90 9 77 87153 1323122 28852 1303828 43 42 33 41 16 17 49 58 78 42 50 32 44 38 40 79 29127 1303977 59 66 1,833 417 1,052 250 441 586 70 80 18273 1304432 835 90 55121 1304417 97 132 73 45 61 91 40 81 192 306 620 1,008 396 128 473 278 82 81774 1305933 115 163 91 73 45 32 53 24 83 45982 1307133 91 150 53 87 25 26 65 1 84 73680 1307136 90 44 50 23 38 57 24 85 84651 1500175 53 58 67 30 41 43 86 43147 1500192 75 46 15 35 19 27 12 15 19 4 87 72412 1500113 29 51 47 32 37 23 35 50 0 88 55317 1500196 2019_Sales_Data_By_School_Grade (+ + 95% Ready A? Accessibility: Unavailable 2:18 PM 799 0 3 O 24'C A O DI ENG 2022-07-26 22 Type here to searchX AutoSave O Off) 2019_Sales_Data_By_School_Grade Search (Alt+Q) Comments Share File Home Insert Draw Page Layout Formulas Data Review Help Foxit PDF Insert Ex AY O LO Calibri v 11 VA A ab Wrap Text General Delete GI $ ~ % " Conditional Format as Cell Sort & Find & Analyze Sensitivity Paste BIU~ E Merge & Center Formatting * Table Styles Format Filter * Select v Data Number Styles Cells Editing Analysis Sensitivity Clipboard Font Alignment X V O P B C D E F G H K L M N A 48558 1501925 96 163 89 99 44 35 114 24 89 90 74158 1501866 375 315 272 238 159 144 132 155 1,217 178 831 263 653 1,005 269 91 67335 1511894 645 54336 1501944 24 39 25 29 11 20 32 5 92 612 166 93 73142 1501878 425 987 442 611 221 588 94 45134 1502762 215 574 201 344 97 183 181 48 95 43225 1505252 105 146 80 94 63 73 104 36 90 80 106 46 79397 1509670 106 31 110 31 96 113 69 84 44 42 94 85 97 98790 1700148 110 248 469 184 469 89 187 115 48 98 71840 1705187 78 112 62 92 50 63 92 21 99 44775 1702079 100 44955 1705174 39 361 24 27 20 22 23 8 101 45313 1710898 63 95 39 50 28 22 58 36 313 394 232 226 121 193 345 27 102 45766 2100709 50 30 103 46139 2100675 77 93 52 61 31 29 2866 2106375 75 156 50 101 35 68 90 2 104 105 67931 2106918 53 65 35 74 23 27 45 31 24328 2107228 65 170 65 100 31 33 101 32 106 326 402 250 450 158 225 102 108 107 52162 2107238 48 59 28 32 58 26 108 48282 2109206 46 74 74557 2109197 92 118 69 82 54 44 73 51 109 52 61 51 46 34 17 33 53 110 95968 2109137 2019_Sales_Data_By_School_Grade (+ ) + 95% Ready A? Accessibility: Unavailable 2:18 PM 799 0 X 24'C A O DI ENG Type here to search 2022-07-26 22X AutoSave O Off) 2019_Sales_Data_By_School_Grade Search (Alt+Q) Comments Share File Home Insert Draw Page Layout Formulas Data Review Help Foxit PDF Insert Ex AY O LO Calibri v 11 VA A ab Wrap Text General Delete Conditional Format as Cell Sort & Find & Analyze Sensitivity Paste BIU~ E Merge & Center $ ~ % " Formatting Table Styles Format Filter * Select v Data Cells Editing Analysis Sensitivity Clipboard Font Alignment Number Styles X V F L O P G H K M N A B C D E 54 54 37 50 22 28 37 58 111 54938 2109226 282 240 124 112 83864 2304575 332 255 158 187 134 42 11 17 52 113 50282 2304582 30 64 26 51 70 38 114 72590 2305576 38 44 15 34 21 22016 2307648 35 79 29 62 25 24 52 20 115 74 84 60 87 23 33 76 78 116 79560 2307616 27 39 27 30 16 25 36 26 117 45774 2311135 71 86 41 22 41 41 118 49961 2500790 93 73 119 140 71 100 64 43 69 76 119 6732 2500798 28 23 28 16 8 17 13 120 83737 2501684 30 46 48 11 16 32 121 38 33 10 98192 2502472 122 7630 2503897 63 134 60 97 29 59 91 23 140 79144 2503882 460 207 311 160 241 238 123 340 104 124 104 128 52 86 143 8 124 76518 2504915 2505890 38 47 38 69 18 25 45 43 125 32 66 30 39 17 22 43 32 126 77920 2700811 64550 2700761 33 24 21 39 12 21 40 27 127 99 119 58 62 36 36 42 13 128 8343 2707990 67 75 42 79 35 31 33 13 129 59873 2707941 62 61 58 67 34 43 49 16 130 98125 2901856 63 35 42 23 11 25 0 131 50265 2900873 35 43 56 104 2900804 113 218 105 101 132 48263 2019_Sales_Data_By_School_Grade + 95% Ready A? Accessibility: Unavailable 2:18 PM 799 0 X 24 C A O DI ENG 2022-07-26 22 Type here to searchX AutoSave O Off) 2019_Sales_Data_By_School_Grade Search (Alt+Q) Comments Share File Home Insert Draw Page Layout Formulas Data Review Help Foxit PDF Insert ZAY LO Calibri v 11 VA A ab Wrap Text General Delete Sort & Find & Sensitivity Paste BIU ~ Merge & Center $ ~ % " Conditional Format as Cell Analyze E Formatting Table Styles Format Filter * Select v Data Styles Cells Editing Analysis Sensitivity Number Clipboard Font Alignment X V D E F G H K L M N O P A B C 7630 2503897 63 134 60 97 29 59 91 23 122 79144 2503882 340 460 207 311 160 241 238 140 123 76518 2504915 104 124 104 128 52 86 143 8 124 125 63345 2505890 38 47 38 69 18 25 45 43 30 22 32 126 77920 2700811 32 66 39 17 43 39 12 21 40 27 127 64550 2700761 33 24 21 8343 2707990 66 119 58 62 36 36 42 13 128 67 75 42 79 35 31 33 13 129 59873 2707941 62 61 58 67 34 43 49 16 130 98125 2901856 35 63 35 42 23 11 25 0 131 50265 2900873 113 218 105 101 43 56 104 2 132 48263 2900804 2900851 57 50 45 54 19 27 43 33 133 34263 2900805 47 84 47 52 15 20 50 46 134 36 42 32 41 19 37 44 28 135 74904 2900874 36 40 30 24 15 14 20 14 136 98822 2900818 182 375 165 304 64 164 179 330 137 46995 2900880 17 33 13 24 11 21 25 7 138 46303 2900835 139 140 141 142 143 2019_Sales_Data_By_School_Grade (+ + 95% Ready Accessibility: Unavailable 2:18 PM 24'C A O O ENG Type here to search 799- 2022-07-26You can view a dashboard of McNelson's data along with Frank's questions to determine the data you should purchase. 4/7Use your budget wisely. There are different tiers within H McNelson's data. The more data a tier contains, the more it E will cost. Carefully analyze the data and Frank's questions before making a purchase. 5/7 Keep in mind that some of Frank's questions cannot be iNCE E answered without purchasing data. But, if you can answer 100 his questions without spending all of your budget, you will have more funds remaining for marketing efforts. 6/7 Once you've downloaded the Buhi and McNelson data, use them to answer Frank's questions in the Analytics Report. ver vill Then, based on your data analyses, determine how to allocate the remaining marketing budget for the high school market in Q3. 6/7 7/7MIMIC Analytics Objectives Results ... . . . . . . Your tasks are to: . Select which data to purchase Round 3 . Answer Frank's questions Basic Data Integration . Recommend budget allocations BUDGET BALANCE $10,000 $5,000 Make sure to check the Guides tab inside the Help menu in the top right corner for extra guidance. Scenario Objectives Let's Review the Process Decisions Analytics Report Recommend Budget Allocation Run Simulation ReadingDecisions You must use Buhi's historical data and Frank's questions to determine which tiers of McNelson U.S. school data to purchase. You can use your $10,000 marketing budget to complete this task. Review Frank's Questions Keep in mind that some of Frank's questions cannot be answered without purchasing data. However, the money you spend will be deducted from your marketing budget) so choose wisely. Buhi Historical High School Sales Data You can download this data for free Q Five-year High School Sales Revenue