Hello, I need to make two charts/graphs in Excel that effectively display the correlation with the following variables:

1.Advertising expense and profit

2.College student population and profit

(I put the store numbers in but do not think you need them, not sure and pasted the data as Course Hero would not let me upload Excel or Word documents. I'm really sorry for the hassle I tried uploading multiple kinds of documents and the site said they were all not supported. The number of the store is the small number, the profit is the data with $ sign on it and the other numerical data is the corresponding advertising expense. They are in order.)

Please make the graphs and send them. If you can in excel please so can modify it and see how was made. If you can also explain how to do them would be great but mainly need them done. I know the basics already. I tried but did not have much time. something with bin numbers or frequencies or something? Thank you!

We have to pick a color scheme and its for a pizza chain so we were talking about yellow and red or something along those lines if you wanted to incorporate those colors, but I can change the color as well myself.

Here is other data I have for it:

12. Give a descriptive title to each Table, Figure, Exhibit.

13. Give a descriptive heading to each row and column in a Table.

14. Include horizontal and vertical axis labels and axis titles for each Figure.

15. Show data "value" on Figures. For example, on a pie or bar chart, show the value corresponding to each slice or bar.

16. Remember: A table or figure must stand alone. That means a person should be able to study it and understand readily what it reveals -- without having to read the paragraphs and written portion of the report!

17. Do NOT just lift a table or chart out of Excel and put it in your paper. Format to make them "user-friendly" and appropriate to have a professional-looking report -- even if it means that you must re-type the information to make it look right:

Align column headings and column entries,

Change the column and row headings (variable names) to be meaningful to the reader

Put borders around the table and around cells,

Scale the size of tables and figures so they are easily legible for the reader

Remove any parts/information that is not useful to, or not addressed in, your report. For example, if skewness is reported by Excel, but it does not relate to your discussion, do not include it in the report.

21. And very importantly, don't lie with statistics! For example, if you are comparing average profit for stores which deliver and those that don't deliver, make sure the two bars start at $0 (or at the same number) so the height difference of the two bars will be meaningful and does not visually deceive the reader.

Someone posted one chart/graph they made and was a bar chart so maybe make one similar in type like bar chart also or whatever you think works best to portray the data is likely the best choice. colors we will use are yellow and red or something pizza related if you want to use those or I will alter it if needed.

Store / Student Population / Monthly Profit Monthly / Advertising expenditure 1 17985 $9,984 1137 2 16237 $8,387 1052 3 15528 $9,679 873 4 20880 $21,591 1890 5 16197 $8,197 887 6 16484 $20,930 1759 7 5051 $3,305 1006 8 3226 -$11,264 908 9 20865 $28,367 1907 10 16494 $18,904 1839 11 4622 $18,934 2338 12 20311 $11,845 2295 13 7588 $15,747 1754 14 12353 $23,107 1908 15 19351 $18,461 2096 16 15571 $2,035 1027 17 14306 $11,771 2020 18 19249 $22,783 2112 19 9813 -$3,619 896 20 12212 $13,326 1810 21 15232 $19,157 1729 22 16587 $16,047 1886 23 10588 $5,675 1136 24 6151 $11,720 2023 25 11284 $4,130 926 26 9820 $8,086 1076 27 20183 $28,319 2490 28 15581 $9,997 1175 29 12482 $12,785 2147 30 19685 $27,153 3446 31 10861 $6,040 1176 32 8613 $13,871 1835 33 8173 -$8,339 1237 34 15912 $18,762 1706 35 21627 $29,030 3004 36 17821 $8,336 1194 37 17213 $9,140 802 38 10851 $10,109 1967 39 21090 $31,273 2099 40 17024 $21,438 2091 41 15909 $25,395 2841 42 21397 $24,190 2376 43 17370 $21,085 2260 44 17228 $24,712 1858 45 19876 $35,222 3315 46 7079 $25,346 2470 47 16311 $13,707 1677 48 8985 $2,104 807 49 3544 -$3,362 906 50 20268 $19,557 2052 51 20101 $28,500 2511 52 3841 -$5,787 867 53 17446 $10,410 2088 54 5183 -$6,766 1010 55 20438 $22,910 1765 56 16350 $17,351 2183 57 6241 -$4,118 954 58 16616 $24,758 2169 59 8469 $7,779 1294 60 6927 $6,663 937