Log out Go to App
Go to App

Learning Materials

Features

Discover

Chapter 4: Q29P (page 93)

Excel LINEST function. Enter the following data in a spreadsheet and use LINEST to find slope, intercept, and standard errors. Use Excel to draw a graph of the data and add a trendline. Draw error bars of±syon the points.

x:3.010.020.030.040.0y:-0.074-1.411-2.584-3.750-5.407

Short Answer

Expert verified

The slope of the given data is-0.13789

The intercept of the given data is0.195343

The standard error of the given data is0.197625

The graph of the given data by the use of the LINEST function is given in step 2.

Step by step solution

01

Determine standard deviation of y : sy and the standard uncertainty of the slope and the intercept

The standard deviation ofyis mathematically represented as

σy≈sy=∑(di2)n-2.

The standard uncertainty of a slope is mathematically represented as

um2=sy2nD.

The standard uncertainty of an intercept is mathematically represented as

ub2=sy2∑(xi2)D.

02

Determine the slope, intercept, and standard errors

The given data is listed below.

Use the Excel LINEST function to calculate the slope, the intercept, and the standard errors.

Use Excel to draw the graph, the error bars of ±syon the points.

Excel LINEST function:

The Excel LINEST function used (Figure 1) to calculate the slope, the intercept and the standard errors; and to draw a graph is shown in Figure 2.

From the spreadsheet, the slope is -0.13789, the intercept is 0.195343and the standard error found is 0.197625

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Start your free trial

Over 30 million students worldwide already upgrade their learning with Vaia!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

What is the relation between the standard deviation and the precision of a procedure? What is the relation between standard deviation and accuracy?

Use Table 4-1 to state what fraction of a Gaussian population lies within the following intervals:

(a)μ±σ

(b)μ±2σ

(c)μto+σ

(d)μto+0.5σ

(e)-σto-0.5σ

Blood plasma proteins of patients with malignant breast tumors differ from proteins of healthy people in their solubility in the presence of various polymers. When the polymers dextran and poly(ethylene glycol) are mixed with water, a two-phase mixture is formed. When plasma proteins of tumor patients are added, the distribution of proteins between the two phases is different from that of plasma proteins of a healthy person. The distribution coefficient ( K) for any substance is defined as K =[concentration of the substance in phase[concentration of the substance in phase B ]. Proteins of healthy people have a mean distribution coefficient of 0.75 with a standard deviation of 0.07. For the proteins of people with cancer, the mean is 0.92 with a standard deviation of 0.11.

(a) Suppose that Kwere used as a diagnostic tool and that a positive indication of cancer is taken asK≥0.92. What fraction of people with tumors would have a false negative indication of cancer becauseK≥0.92?

(b) What fraction of healthy people would have a false positive indication of cancer? This number is the fraction of healthy people withK≥0.92, shown by the shaded area in the graph below. Estimate an answer with Table 4 - 1 and obtain a more exact result with the NORMDIST function in Excel.

(c) Vary the first argument of the NORMDIST function to select a distribution coefficient that would identify 75% of people with tumors. That is, 75% of patients with tumors would have K above the selected distribution coefficient. With this value of K, what fraction of healthy people would have a false positive result indicating they have a tumor?

For the numbers 116.0,97.9,114.2,106.8and 108.3, find the mean, standard deviation, standard uncertainty ( = standard deviation of the mean), range, and 90% confidence interval for the mean. Using the Grubbs test, decide whether the number 97.9should be discarded.

Nonlinear calibration curve. Following the procedure in Box 4-2, find how many micrograms (μg)of protein are contained in a sample with a corrected absorbance of 0.350in Figure 4-13.
See all solutions

Recommended explanations on Chemistry Textbooks

Making Measurements

Read Explanation

Inorganic Chemistry

Read Explanation

Kinetics

Read Explanation

Organic Chemistry

Read Explanation

The Earths Atmosphere

Read Explanation

Ionic and Molecular Compounds

Read Explanation
View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.

Sign-up for free