Monthly advertising expenditures ($)	New worker's compensation cases
$9,221.55	26
$6,684.00	33
$200.00	18
$14,546.75	15
$5,170.14	19
$5,810.30	26
$5,816.20	24
$8,236.38	22
-$2,089.55	12
$29,282.24	15
$9,193.58	21
$9,499.18	24
$11,128.76	25
$9,057.64	19
$13,604.54	12
$14,411.76	33
$13,724.28	32
$13,419.42	21
$17,372.33	18
$6,296.35	25
$13,191.59	12
$26,798.80	7
$18,610.95	22
$829.53	27
$16,976.53	25
$14,076.98	26
$24,791.75	28
$9,691.25	31
$28,948.25	40
$21,373.52	39
$9,675.25	41
$33,213.55	48
$19,859.85	28
$10,475.25	29
$24,790.84	20
$36,660.94	27
$8,812.50	26
$41,817.75	45
$27,399.33	30
$25,723.10	33
$16,312.10	24
$26,332.78	40
$60,207.58	36
$42,485.39	29
$35,601.92	17
$72,071.50	13
$12,797.11	15
$12,310.50	16

Question 6

Use the following information for Questions 6 - 8.

A law firm had two partners: Partner A handled personal injury cases, while Partner B handled only worker's compensation cases. The firm's advertising was focused on personal injury only. The lawyers decided to end their partnership, and Partner A sued Partner B over who should pay what share of the expenses of their former partnership. Partner A claimed that the ads resulted in the firm getting more worker's compensation cases for Partner B, so Partner B should share the advertising costs. You will create some of the plots and conduct some of the analyses to asses this claim.

Create scatterplot of using "New worker's compensation cases" as the y-variable and "Monthly advertising expenditures ($)" as the x-variable . The data can be found in thesheet "Q6-8".

Make sure to clearly label the axes including measurement units whenever possible. You do not need to include a title.

Create plot in Excel. Right-click on the plot and "Save as Picture...". Save as a PNG or JPEG file. Then in the text box below, choose Insert > Image > Upload Image. If you are having trouble saving the image from Excel, click somewhere outside of the graph, then take a screenshot and crop it to include only the contents of the graph.

Question 7

What is the value of the correlation co-efficient for the relationship between "New worker's compensation cases" and "Monthly advertising expenditures ($)"? Answer to four decimal places as needed.

Question 8

Create the residual plot (Residuals vs. "Monthly advertising expenditures ($)") for the regression predicting "New worker's compensation cases" from "Monthly advertising expenditures ($)".

Make sure to clearly label the axes including measurement units whenever possible. You do not need to include a title.

Create plot in Excel. Right-click on the plot and "Save as Picture...". Save as a PNG or JPEG file. Then in the text box below, choose Insert > Image > Upload Image. If you are having trouble saving the image from Excel, click somewhere outside of the graph, then take a screenshot and crop it to include only the contents of the graph.

Question 9

A spa offers massages of different lengths: 60 minutes, 90 minutes, 120 minutes. Using their historical data, they found that 55% of clients choose 60-minute massages, 35% of clients choose 90-minute massages, and the remainder of customers choose 120-minute massages.

Find the expected value and standard deviation for length of massage (in minutes). Answer to two decimal places as needed.

Expected value = _ minutes

Standard deviation = _ minutes