Question

For the following data: x 1.4 2.4 4.0 4.9 5.7 6.3 7.8 9.0 9.3 11.0 v 2.3 3.7 5.7 9.9 6.9 15.8 15.4 36.9 34.6 53.2 a. Make a scatterplot of y versus x. Is the relationship between r and y approximately linear, or is it nonlinear? b. Compute the natural logarithm of each y value. This is known as making a log transformation of y. Make a scatterplot of In y versus x. Is the relationship between x and In y approximately linear, or is it nonlinear? c. In general, it is easier to work with quantities that have an approximate linear relationship than with quantities that have a nonlinear relationship. For these data, do you think it would be easier to work with x and y or with x and In y? Explain.
0 0
Add a comment Improve this question Transcribed image text
Answer #1


Book1 Excel (Product Activation Failed) HOME INSERT PAGE LAYOLT FORMULAS DATA REVIEW EW cut Copy . Sign i 2 Hill aste B l u .凼. 2. . -_- 4e47 F Merge & Center . s-% , conditional tormatas Neutral Check Cell Insert Delete Format ClestFilter-Selert Sort Hind B or Format Painter rmatting Tahlr Edtng 1.4 2.1 Scatter Plot 4.9 5.7 6.3 7.8 15.8 53.2 14 19 Sheet1 ョ1 - 1040 AM O Type here to search 1/27/2019

a) From scatter plot, there is positive linear relationship between x and y.


Book1 Excel (Product Activation Failed) HOME INSERT PAGE LAYOLT FORMULAS DATA REVIEW EW cut Copy . Sign i 2 Hill . 2. .--- se47 F Merge & Center . s-% , conditional tormatas Neutral B 1 u . Check Cell Insert Delete Format ClestFilter-Selert Sort Hind B or Format Painter rmatting Tahlr Edtng l ogY 1.4 2.1 Scatter Plot 4.9 5.7.84 .31.20 7.8 1.00 Sheell | Sheet2 ョ1 +101% - 1046 AM O Type here to search 1/27/2019

b) From scatter plot, there is perfect positive linear relationship between x and y.

c) In part a we have positive linear relationship between x and y and in part b we have perfect positive linear relationship between x and y therefore it would be easier to work with x and ln y.

Add a comment
Know the answer?
Add Answer to:
For the following data: x 1.4 2.4 4.0 4.9 5.7 6.3 7.8 9.0 9.3 11.0 v...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Using the data file provided with both variables, x and y, answer the following questions using...

    Using the data file provided with both variables, x and y, answer the following questions using Excel*: 1.Create a scatterplot with the data. Comment on direction, form, strength, outliers and/or other significant findings. 2.Use the linear model to fit a line to the data and determine the equation ỹ = b0 + b1x and Interpret b0and b1. 3.Calculate the coefficient of correlation. Discuss the strength of correlation between the explanatory and response variables. 4.Predict the value for ỹ when you...

  • CASE 1-5 Financial Statement Ratio Computation Refer to Campbell Soup Company's financial Campbell Soup statements in...

    CASE 1-5 Financial Statement Ratio Computation Refer to Campbell Soup Company's financial Campbell Soup statements in Appendix A. Required: Compute the following ratios for Year 11. Liquidity ratios: Asset utilization ratios:* a. Current ratio n. Cash turnover b. Acid-test ratio 0. Accounts receivable turnover c. Days to sell inventory p. Inventory turnover d. Collection period 4. Working capital turnover Capital structure and solvency ratios: 1. Fixed assets turnover e. Total debt to total equity s. Total assets turnover f. Long-term...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT