Please provide step by step explanation on how to do all parts - either in Excel, JMP, or with general formulas.

The accompanying data table contains financial data for 30 random technology companies. One column gives the expenses on research and development (R&D), and another gives the total assets of the 30 companies. Both of these columns are reported in millions of dollars. The data need to be expressed on a log scale; otherwise, two outlying companies dominate the analysis. Use the natural logs of both variables rather than the original variables in the data table. (Note that the variables are recorded in millions, so 1,000 = 1 billion.) Complete parts (a) through (C). Click the icon to view the data table of R&D expenses and total assets. (a) What difference in R&D spending (as a percentage) is associated with a 1% increase in the assets of a firm? Give your answer as a range. A difference between 0.800 % and 0.873 % in R&D spending is associated with a 1% increase in the assets of a firm. (Round to three decimal places as needed.) (b) Revise your model to use base 10 logs of assets and R&D expenses. Does using a different base for both log transformations affect your answer to part (a)? Select the correct choice below and, if necessary, fill in the answer boxes in your choice. %. A. Yes. The new difference is between % and (Round to three decimal places as needed.) B. No. The answer to part (a) remains the same. (C) Find a 95% prediction interval for the R&D expenses of a firm with $1 billion in assets. Be sure to express your range on a dollar scale. Do you expect this interval to have 95% coverage? The R&D expenses for a firm with $1 billion in assets would be between $ 42.4 million and $ 185.7 million. (Round to one decimal place as needed.) at least 95% of the observations, so it should be expected that the interval will have 95% When graphing all prediction intervals, they appear to cover coverage. U Assets 1,523.40 5.17 57.88 227.35 44.10 156.52 97,987.97 4.04 4.96 2,848.65 46,765.45 0.29 21.82 141.53 10,000.60 4,578.84 656.62 1.76 0.31 7,092.55 129.79 250.26 7,641.12 118.78 0.48 147.95 0.40 14,106.63 46.10 2,170.69 R&D 128.69 0.83 10.05 31.72 4.71 23.54 7,660.25 1.14 1.39 145.84 4,277.83 0.16 4.78 9.82 660.04 233.41 34.08 0.29 0.09 553.58 18.16 37.48 318.46 12.55 0.20 21.98 0.10 483.57 6.07 167.35 Log Assets 7.3287 1.6421 4.0583 5.4265 3.7864 5.0532 11.4926 1.3967 1.6014 7.9546 10.7529 - 1.2368 3.0829 4.9525 9.2104 8.4292 6.4871 0.5665 - 1.1847 8.8668 4.8659 5.5225 8.9413 4.7773 -0.7295 4.9969 -0.9171 9.5544 3.8309 7.6828 Log R&D 4.8574 - 0.1849 2.3078 3.4571 1.5499 3.1589 8.9438 0.1331 0.3314 4.9825 8.3612 - 1.8513 1.5644 2.2848 6.4923 5.4528 3.5287 - 1.2243 -2.3705 6.3164 2.8994 3.6237 5.7635 2.5299 - 1.6313 3.0903 - 2.2884 6.1812 1.8038 5.1201 Log 10 Assets 3.1828 0.7132 1.7625 2.3567 1.6444 2.1946 4.9912 0.6066 0.6955 3.4546 4.6699 -0.5371 1.3389 2.1508 4.0000 3.6608 2.8173 0.2460 -0.5145 3.8508 2.1132 2.3984 3.8832 2.0748 -0.3168 2.1701 -0.3983 4.1494 1.6637 3.3366 Log 10 R&D 2.1095 -0.0803 1.0023 1.5014 0.6731 1.3719 3.8842 0.0578 0.1439 2.1639 3.6312 -0.8040 0.6794 0.9923 2.8196 2.3681 1.5325 -0.5317 - 1.0295 2.7432 1.2592 1.5738 2.5031 1.0987 -0.7085 1.3421 -0.9938 2.6845 0.7834 2.2236 The accompanying data table contains financial data for 30 random technology companies. One column gives the expenses on research and development (R&D), and another gives the total assets of the 30 companies. Both of these columns are reported in millions of dollars. The data need to be expressed on a log scale; otherwise, two outlying companies dominate the analysis. Use the natural logs of both variables rather than the original variables in the data table. (Note that the variables are recorded in millions, so 1,000 = 1 billion.) Complete parts (a) through (C). Click the icon to view the data table of R&D expenses and total assets. (a) What difference in R&D spending (as a percentage) is associated with a 1% increase in the assets of a firm? Give your answer as a range. A difference between 0.800 % and 0.873 % in R&D spending is associated with a 1% increase in the assets of a firm. (Round to three decimal places as needed.) (b) Revise your model to use base 10 logs of assets and R&D expenses. Does using a different base for both log transformations affect your answer to part (a)? Select the correct choice below and, if necessary, fill in the answer boxes in your choice. %. A. Yes. The new difference is between % and (Round to three decimal places as needed.) B. No. The answer to part (a) remains the same. (C) Find a 95% prediction interval for the R&D expenses of a firm with $1 billion in assets. Be sure to express your range on a dollar scale. Do you expect this interval to have 95% coverage? The R&D expenses for a firm with $1 billion in assets would be between $ 42.4 million and $ 185.7 million. (Round to one decimal place as needed.) at least 95% of the observations, so it should be expected that the interval will have 95% When graphing all prediction intervals, they appear to cover coverage. U Assets 1,523.40 5.17 57.88 227.35 44.10 156.52 97,987.97 4.04 4.96 2,848.65 46,765.45 0.29 21.82 141.53 10,000.60 4,578.84 656.62 1.76 0.31 7,092.55 129.79 250.26 7,641.12 118.78 0.48 147.95 0.40 14,106.63 46.10 2,170.69 R&D 128.69 0.83 10.05 31.72 4.71 23.54 7,660.25 1.14 1.39 145.84 4,277.83 0.16 4.78 9.82 660.04 233.41 34.08 0.29 0.09 553.58 18.16 37.48 318.46 12.55 0.20 21.98 0.10 483.57 6.07 167.35 Log Assets 7.3287 1.6421 4.0583 5.4265 3.7864 5.0532 11.4926 1.3967 1.6014 7.9546 10.7529 - 1.2368 3.0829 4.9525 9.2104 8.4292 6.4871 0.5665 - 1.1847 8.8668 4.8659 5.5225 8.9413 4.7773 -0.7295 4.9969 -0.9171 9.5544 3.8309 7.6828 Log R&D 4.8574 - 0.1849 2.3078 3.4571 1.5499 3.1589 8.9438 0.1331 0.3314 4.9825 8.3612 - 1.8513 1.5644 2.2848 6.4923 5.4528 3.5287 - 1.2243 -2.3705 6.3164 2.8994 3.6237 5.7635 2.5299 - 1.6313 3.0903 - 2.2884 6.1812 1.8038 5.1201 Log 10 Assets 3.1828 0.7132 1.7625 2.3567 1.6444 2.1946 4.9912 0.6066 0.6955 3.4546 4.6699 -0.5371 1.3389 2.1508 4.0000 3.6608 2.8173 0.2460 -0.5145 3.8508 2.1132 2.3984 3.8832 2.0748 -0.3168 2.1701 -0.3983 4.1494 1.6637 3.3366 Log 10 R&D 2.1095 -0.0803 1.0023 1.5014 0.6731 1.3719 3.8842 0.0578 0.1439 2.1639 3.6312 -0.8040 0.6794 0.9923 2.8196 2.3681 1.5325 -0.5317 - 1.0295 2.7432 1.2592 1.5738 2.5031 1.0987 -0.7085 1.3421 -0.9938 2.6845 0.7834 2.2236