
Patrick B. answered 08/26/20
Math and computer tutor/teacher
I have uploaded the spreadsheet for you..
Here are the results:

J S.
asked 08/26/20Darth Vader kept track of the number of advertisements he placed in local newspapers each day and the number of new recruits to the Galactic Empire each day:
You MAY wish to complete this table to help you answer questions (b) and (c) below.
# of ADS | # NEW RECRUITS | |||
6 | 20 | |||
5 | 15 | |||
3 | 12 | |||
2 | 8 | |||
1 | 6 | |||
4 | 7 | |||
3 | 9 | |||
a = n(∑xy) − (∑x)(∑y)
a) Determine the line of best fit y = ax + b , using the formulas n(∑x2 ) − (∑x)2 and
b = y − ax
Show all your work. Round answers to 2 decimal places.
b) Calculate the correlation coefficient for the set of data using the formula, and classify the correlation.
Patrick B. answered 08/26/20
Math and computer tutor/teacher
I have uploaded the spreadsheet for you..
Here are the results:
Get a free answer to a quick problem.
Most questions answered within 4 hours.
Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.
Patrick B.
the spreadsheet is in the resources section. Filename: Best Fit Trend Line and R Coefficient.xls08/26/20