[Solved]Question 6 20 Points Short Questions Asked Perform Operations Numbers Contained Cell Use C Q37192160
Hi, I need some excel help. Thank you in advance.
Question 6 (20 points) Short questions. When asked to perform operations on the numbers contained in a cell, do use the cell reference (e.g., A1, A2, A3) instead of the numeric values. (a) Two sets of y values are shown. The noisy data were calculated from the clean data by adding random values. Try linear regression on these data sets. What is the impact of noisy data on the calculated slope, intercept, and R2 value? clean noisv 0.85 1.91 3.03 4 3.96 5.10 4 5.90 (b) Consider the following Bessel function The solutions are at x = 0 and near x = 4 and x 7. Use the Solver with Excel’s BESSELJ function to find more precise values for the roots near 4 and 7. The order of the Bessel function is 1 (c) Describe how can the following graph be obtained in Excel. A short description suffices. You do not need to plot the graph. Female Male .17% 23% 27% 18% 18% 25% 28% 17% 9% 2% 1% 100% 2 <21 >70 70 60 50 40 30 30 40 50 60 70 5% 3% 100% 8 70 Male Female 12 13 15 16 40% 20% 20% 0% 40% 20 (d) When testing the performance of a biomedical device, the following results are obtained: Error 5.0% 5.1% 5.0% 5.0% 5.0% 5.0% 0.32 0.55 0.88 1.42 2.40 4.81 All the data points demonstrate a 5.0% error except when x-1. In Excel, is it possible to show different errors values in the form of error bars? A short discussion suffices. You do not need to make the plot. (e) Study the following two figures. Describe the differences using the plot function in MATLAB 12 12 10 10 12 10 12 10 Show transcribed image text Question 6 (20 points) Short questions. When asked to perform operations on the numbers contained in a cell, do use the cell reference (e.g., A1, A2, A3) instead of the numeric values. (a) Two sets of y values are shown. The noisy data were calculated from the clean data by adding random values. Try linear regression on these data sets. What is the impact of noisy data on the calculated slope, intercept, and R2 value? clean noisv 0.85 1.91 3.03 4 3.96 5.10 4 5.90 (b) Consider the following Bessel function The solutions are at x = 0 and near x = 4 and x 7. Use the Solver with Excel’s BESSELJ function to find more precise values for the roots near 4 and 7. The order of the Bessel function is 1 (c) Describe how can the following graph be obtained in Excel. A short description suffices. You do not need to plot the graph.
Female Male .17% 23% 27% 18% 18% 25% 28% 17% 9% 2% 1% 100% 2 70 70 60 50 40 30 30 40 50 60 70 5% 3% 100% 8 70 Male Female 12 13 15 16 40% 20% 20% 0% 40% 20 (d) When testing the performance of a biomedical device, the following results are obtained: Error 5.0% 5.1% 5.0% 5.0% 5.0% 5.0% 0.32 0.55 0.88 1.42 2.40 4.81 All the data points demonstrate a 5.0% error except when x-1. In Excel, is it possible to show different errors values in the form of error bars? A short discussion suffices. You do not need to make the plot. (e) Study the following two figures. Describe the differences using the plot function in MATLAB 12 12 10 10 12 10 12 10
Expert Answer
Answer to Question 6 (20 points) Short questions. When asked to perform operations on the numbers contained in a cell, do use the … . . .
OR
