Case 8-1 As the Senior Accountant for a Manufacturing Company, You Have

Case 8-1
As the senior accountant for a manufacturing company, you have many years experience working with Excel and often provide help and tips on using Excel to the company's more junior accountants.
-After lunch, Jim in purchasing and sales accounting gives you a call. He is working with a workbook containing budgeting worksheets and charts created by a temporary employee, who is no longer working at the company. One of the line charts includes a linear trendline that looks really strange. Jim wants to know how he can verify the precision of the trendline. You tell Jim to ____.

A) display the R-squared value for the trendline; the closer the value is to 0, the more accurate the trendline
B) rechart the data and add an exponential trendline
C) display the R-squared value for the trendline; the closer the value is to 1, the more accurate the trendline
D) call the agency who provided the temporary employee and ask them to send a new temporary employee to fix the problem

Correct Answer:

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Access For Free