Question: Linearise the activity data and use the Excel Data Analysis tool on the linearised activity data to perform the linear regression. Show the plot with

Linearise the activity data and use the Excel Data Analysis tool on the linearised activity data to perform the linear regression. Show the plot with the fitted model. Make sure that the plot has the right format, dont just copy-paste directly from the Data Analysis tool.
The Excel Data Analysis tool shows the values of the gradient and y-intercept with errors, the R2 coefficient and the standard residual error. Remember how we present values with errors.
What is the initial activity of your sample with an error? Is this value similar to the value you got from the trendline? Remember units. Hint: exx=ex
\begin{tabular}{|c|c|c|}
\hline time [year] & & activity [decays/year]\\
\hline & 6.034 & 851.5541961\\
\hline & 12.068 & 822.9824422\\
\hline & 18.102 & 674.4913072\\
\hline & 24.136 & 607.3277296\\
\hline & 30.17 & 481.2408616\\
\hline & 36.204 & 442.3004956\\
\hline & 42.238 & 415.0014536\\
\hline & 48.272 & 323.1396119\\
\hline & 54.306 & 290.9762715\\
\hline & 60.34 & 242.1430179\\
\hline & 66.374 & 205.3722695\\
\hline & 72.408 & 183.6680006\\
\hline & 78.442 & 150.701964\\
\hline & 84.476 & 134.2451686\\
\hline & 90.51 & 130.4213685\\
\hline & 96.544 & 103.4823838\\
\hline & 102.578 & 102.5330688\\
\hline & 108.612 & 77.64029652\\
\hline & 114.646 & 78.93955688\\
\hline & 120.68 & 67.97034887\\
\hline & 126.714 & 49.47359145\\
\hline & 132.748 & 47.58894896\\
\hline & 138.782 & 43.7041077\\
\hline & 144.816 & 32.85125859\\
\hline & 150.85 & 32.09387932\\
\hline & 156.884 & 27.90359095\\
\hline & 162.918 & 23.59212492\\
\hline & 168.952 & 18.62865543\\
\hline & 174.986 & 16.47254554\\
\hline & 181.02 & 14.89313115\\
\hline & 187.054 & 13.28344931\\
\hline & 193.088 & 10.88209796\\
\hline & 199.122 & 9.395333537\\
\hline & 205.156 & 8.497836234\\
\hline & 211.19 & 7.859285711\\
\hline & 217.224 & 7.002703769\\
\hline & 223.258 & 5.572531782\\
\hline & 229.292 & 4.786123255\\
\hline & 235.326 & 4.670994147\\
\hline & 241.36 & 4.143669681\\
\hline
\end{tabular}
Linearise the activity data and use the Excel

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!