Question:

1) Create scatter chart of the raw data in a new worksheet. (15 marks)??

?

a. Show all of the values for each of the two dependent variables against the value of the independent variable. (6 marks)??

??

b. Assuming that the counts are accurate within 5%, add 'error bars' to those values for each dependent variable at each thickness. (1 mark)??

??

c. Add a linear trend line for each series, and make sure the equation and the coefficient of determination (R2) are both shown for each trendline. (2 marks)??

??

d. Add an exponential trend line for each series, with the equation and the coefficient of determination showing for each. (1 mark)??

??

e. With the use of appropriate formatting (titles, labels, axes, location, colour, bold face, line, thickness, etc.), improve the chart to show what you can about these two series of data. (3 marks)??

??

f. With the use of appropriate formatting, highlight the trend line and related labels that you think better describe each series. (2 marks)??

??

As we can see, we could manipulate this data further!??

??

2) Transform the data provided. (5 marks)??

??

a. In a new column for each material, use the LN function to calculate the natural logarithm (exponent base e) for each counts value - we can call this Ln(counts). (4 marks)??

??

b. Use appropriate formatting (fill colour, borders, font colour/style/size), ensure the new columns are clearly marked as not original data. (1 mark)??

??

3) Create scatter chart of the transformed data in another new worksheet. (5 marks)??

??

a. Copy the earlier chart. For each of the two data series, change the dependent variable source from the raw data columns to the transformed data column. (3 marks)??

??

b. Examine the trend lines; keep only the best one per data series. (1 mark)??

??

c. Update the titles, axis labels and so forth to accurately represent the contents of the new chart. (1 mark)??

??

Examine the coefficients in the equations for the trend lines for each variable in each chart, and their coefficients of determination. You should see that the coefficients for the exponential trend line on the first chart are exactly the same as those for the linear trend line on the second chart. Think about why that is.??

4) Using the Data Analysis tool in Excel, perform four regression analyses. (10 marks)????

a. Perform a regression analysis for each dependent variable, with residual, probability and line fit plots: Al raw, Pb raw, Al transformed, and Pb transformed. Include each on a clearly-named separate new worksheet in your spreadsheet. (4 marks)??

??

b. Fill in the four tables in the 'Questions' tab of your spreadsheet. (6 marks)??

5) Share the absorption coefficients for each material and radiation (5 marks). The absorption coefficient is the negative of the slope of the transformed data, because the reduction in the counts reflects an amount of absorption of radiation. You must provide six significant digits.??

??

a. Fill in the chart in the 'Questions' tab of your spreadsheet. (5 marks)??

results An instructor asked five students how many hours they had studied for an exam, with the accompanying Hours Studied Test Grade 11 51 97 6 8 84 73 62 24) Figure the correlation coefficient (r) by filling in the blanks. Hours Studied Test Grade Cross X X-M. Products (X-M.) Y Y-My (Y-M.) ZY Z. ZY 0 -6.2 38.44 -1.72 51 11 -22.4 501.76 4.8 -1.39 2 39 23.04 97 23.6 556.96 1.46 6 -0.2 0.04 -0.06 84 10.6 112.36 0.66 ? 1.8 3.24 0.50 73 -0.4 -0.02 -0.0 6 -0.2 0.04 -0.06 62 -11.4 129.96 -0.71 7 E= 31 E= 64.8 E-367 2- 1301.2 My = 6.20 SD-=12.96 M,=? SD -? SD=3.60 SD-? Answer: r= 25) Determine the cutoff score(s) for this two-tailed test, using the .01 significance level. (Use a comma to separate answers as needed.) Answer: 26) Determine the test statistic. Answer: 27) Decide whether to reject the null hypothesis. Choose the correct answer below. A. Do not reject the null hypothesis. The results are inconclusive. B. Reject the null hypothesis. The results prove that the research hypothesis is true. C. Do not reject the null hypothesis. The results prove that the null hypothesis is true. D. Reject the null hypothesis. The results support the research hypothesis. Answer:QUESTION 1 1 points Save Answer Use the table for the Poisson Distribution to find F(5;6.4) QUESTION 2 1 points Save Answer Use the table for the Poisson distribution to find f(5; 6.4) QUESTION 3 1 points Save Answer Use the table for the Poisson Distribution to find: 13 E f ( k; 9.5) k =8Question 20 (3 points) A type II error occurs when The null hypothesis is rejected when the null hypothesis is true. O The null hypothesis is not rejected when the null hypothesis is true. The null hypothesis is rejected when the alternate hypothesis is true. The null hypothesis is not rejected when the alternate hypothesis is true.Question 7 (2 points) Complete the following sentence: When conducting a hypothesis test, we and then evaluate the test results to determine if there is enough evidence to Assume that the null hypothesis is true; reject the null hypothesis Assume that the null hypothesis is false; accept the null hypothesis Assume that the alternative hypothesis is true; reject the null hypothesis )Assume the alternative hypothesis is false; reject the alternative hypothesis