Correlation coefficient and Excel graphing. Synthetic data are given below for a calibration curve in which random
Question:
(a) Enter concentration in column A and signal in column B of a spreadsheet. Prepare an XY (Scatter) chart of signal versus concentration without a line as described in Section 2 11. Use LINEST (Section 4-7) to find the least-squares parameters including R2.
(b) Now insert the Trend line by following instructions in Section 4-9. In the Options window used to select the Trend line, select Display Equation and Display R-Squared. Verify that Trend line and LINEST give identical results.
(c) Add 95% confidence interval y error bars following the instructions at the end of Section 4-9. The 95% confidence interval is ± tsy, where sy comes from LINEST and Student's t comes from Table 4-2 for 95% confidence and 11 - 2 = 9 degrees of freedom. Also, compute t with the statement "TINV(0.05,9)"
.png)
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
LINEST gives m b sm Sb R2 and sy in cells B19C21 TRENDLINE pro...View the full answer
Answered By
Asim farooq
I have done MS finance and expertise in the field of Accounting, finance, cost accounting, security analysis and portfolio management and management, MS office is at my fingertips, I want my client to take advantage of my practical knowledge. I have been mentoring my client on a freelancer website from last two years, Currently I am working in Telecom company as a financial analyst and before that working as an accountant with Pepsi for one year. I also join a nonprofit organization as a finance assistant to my job duties are making payment to client after tax calculation, I have started my professional career from teaching I was teaching to a master's level student for two years in the evening.
My Expert Service
Financial accounting, Financial management, Cost accounting, Human resource management, Business communication and report writing. Financial accounting : • Journal entries • Financial statements including balance sheet, Profit & Loss account, Cash flow statement • Adjustment entries • Ratio analysis • Accounting concepts • Single entry accounting • Double entry accounting • Bills of exchange • Bank reconciliation statements Cost accounting : • Budgeting • Job order costing • Process costing • Cost of goods sold Financial management : • Capital budgeting • Net Present Value (NPV) • Internal Rate of Return (IRR) • Payback period • Discounted cash flows • Financial analysis • Capital assets pricing model • Simple interest, Compound interest & annuities
65+ Reviews
86+ Question Solved
Related Book For 
Question Posted:
