Question: Download the full data set from the McGraw-Hill Connect website (only six data values are shown). (a) Use Excel to make a scatter plot, placing
Download the full data set from the McGraw-Hill Connect® website (only six data values are shown).
(a) Use Excel to make a scatter plot, placing Revenue on the X-axis and Net Income on the Y-axis. Add titles and modify the default colors, fonts, etc., as you judge appropriate to make the scatter plot effective.
(b) Describe the relationship (if any) between X and Y. Weak? Strong? Negative? Positive? Linear? Nonlinear?
.png)
Revenue and Net Income (millions) for 27 Randomly Chosen Fortune 1000 Companies O Revenuelncome Revenue Company Net Income 30.8 328.9 90.5 1,494.9 1,523.2 1,565.8 11,066.8 11,164.2 19,468.0 25 168.2 26 27 253.6 496.5 123
Step by Step Solution
3.45 Rating (161 Votes )
There are 3 Steps involved in it
a b There is a fairly weak but positive relationship between Net Income and Revenue ... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
1311-M-S-P(10815).docx
120 KBs Word File
