Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

2.3 creating scatter plots answers

27/10/2021 Client: muhammad11 Deadline: 2 Day

Regression Assignment / Business Calculus

REGRESSION ASSIGNMENT

Due: January 20, 2017 In real-world applications we often encounter numerical data in the form of a table. The

powerful mathematical tool Regression Analysis is a process for finding a function that provides a useful model for a set of data points. One uses computer software to create a graph (a scatter plot) of the set of points and find the function of best fit. The function can then be used to predict values of the dependent variable y for any given value of the independent variable x.

Review §1.3, 2.3, 2.5, of the textbook and try the following example before starting the assignment.

1. Example

Prices for round-shaped diamonds taken from an online trader are given in Table 1. Weight is the independent variable x and price is the dependent variable y. We will analyze this data in the computer.

For Windows users, I suggest using Excel (Microsoft Office). For Mac users, I suggest using Numbers (iWork ’09 or higher). If you do not have this software, it is available in the university computer labs. More information about the available software can be found at

http://its.uncg.edu/Software/.

For Excel and Numbers, enter chart into the Help menu to find out how to create charts, and enter trend into the Help menu to find detailed instructions on creating and manipu- lating trendlines for data series.

In Excel, you can adjust the precision in the trendline equations by clicking on the trendline equation.

Table 1. Prices for round-shaped diamonds

Weight (carats) Price ($)

0.5 2790 0.6 3191 0.7 3694 0.8 4154 0.9 5018 1.0 5898

(1) Enter the data into a spreadsheet (including the header Weight and Price). (2) Create a scatter plot of the data. Note that the scatter plot for this data appears

roughly linear. (3) Compute the linear regression equation (trendline). The trendline will be y = ax + b

for some values of a and b. (4) Adjust the minimum/maximum values on the axes of the graph to 0.4 and 1.2 for

the weight and 2000 and 6500 for the price to make the graph look nice. 1

http://its.uncg.edu/Software/
2 MAT 120-81D REGRESSION ASSIGNMENT

A sample of the output created on Mac Numbers is given below. The regression equation y = 6137.4x−478.9 is on the graph. To predict the price of a diamond weighing 0.85 carats, calculate price by plugging in x = 0.85 into the regression equation

y = 6137.4(0.85) − 478.9 = $4737.89.

Weight (carats)

Price ($)

0.5 $2,790.00 0.6 $3,191.00 0.7 $3,694.00 0.8 $4,154.00 0.9 $5,018.00 1.0 $5,898.00

$2,000.00

$3,125.00

$4,250.00

$5,375.00

$6,500.00

0.4 0.6 0.8 1 1.2

y = 6137.4x - 478.9

Diamond prices

Weight (carats) Price

Diamond Prices for round-shaped diamonds

Predicted price for 0.85 carat diamond: $4,737.89

2. Assignment

Complete the following exercises in Excel, Numbers, or similar software. Save your work often. You answers should be entered in the Regression Assignment under the TESTS tab of MyMathLab. Your work can be submitted any time before the due date.

Exercises.

(1) Table 2 contains price-supply data and price-demand data for soybeans. • Enter the data into a spreadsheet. • Create the scatter plots for the price-supply, where x is the supply (in billions

of bushels) and y is the price (in dollars). • Adjust the minimum and maximum of the axes of each plot to slightly below

and slightly above the data values. • Compute the regression equations for supply using linear regression on each of

the plots. The trendline will be y = ax + b for some values of a and b. Round a and b to 3 decimal places.

(2) Table 3 contains data for fuel consumption (mpg) of an outboard motor at various rpm.

MAT 120-81D REGRESSION ASSIGNMENT 3

Table 2. Supply for soybeans.

Supply (billion bu) Price ($/bu)

1.55 5.11 1.86 5.55 1.94 5.78 2.08 6.15 2.15 6.20 2.27 6.45

• Enter the data into a spreadsheet so that x represents the rpm in thousands. e.g. enter x = 1.5 for 1500, enter x = 2.0 for 2000 etc. • Create the scatter plot for the fuel consumption y (mpg) as a function of engine

speed x (rpm). • Adjust the minimum and maximum of the axes of each plot to slightly below

and slightly above the data values. • Compute the regression equation using quadratic (polynomial order 2) regres-

sion. The trendline will be y = ax2 +bx+c for some values of a, b, and c. Round a, b, and c, to 3 decimal places. • Use your regression equation to estimate the fuel consumption at 2100 rpm

(x = 2.1).

Table 3. Fuel consumption for outboard motor.

rpm mpg

1500 8.4 2000 6.5 2500 4.8 3000 4.0 3500 3.7

1. Example
2. Assignment
Exercises

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Supreme Essay Writer
Quality Homework Helper
Top Academic Guru
Fatimah Syeda
Engineering Solutions
Engineering Exam Guru
Writer Writer Name Offer Chat
Supreme Essay Writer

ONLINE

Supreme Essay Writer

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$36 Chat With Writer
Quality Homework Helper

ONLINE

Quality Homework Helper

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$43 Chat With Writer
Top Academic Guru

ONLINE

Top Academic Guru

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$21 Chat With Writer
Fatimah Syeda

ONLINE

Fatimah Syeda

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$35 Chat With Writer
Engineering Solutions

ONLINE

Engineering Solutions

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$18 Chat With Writer
Engineering Exam Guru

ONLINE

Engineering Exam Guru

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$21 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Michelin fleet solutions case study pdf - What's driving porsche case study - Clash of the ozarks soundtrack - Tae assessor skill set - The dramatic structure of hamlet - History - Mount granya state park - QEP Activity 3 - UNIT DISCUSSION 2: Chapters 3 and 4 (week 3 and 4): Cognitions and Brain (development)... - Goals for impaired physical mobility - Joinder of claims and parties - Wavell the viceroy's journal - Harry cooper supply co - Cpk and sigma level - Grafton district golf club - Descartes method of doubt sparknotes - 10 plagues egyptian gods chart - Tv antenna tower collapse case study - Virgil book 2 translation - Campbellsville university cpt rules - 1628 jasmine drive schertz tx - Erin andrews v marriott international inc et al - 75 kg to 60 kg - Lamar lumber buys 8 million of materials - Millikan oil drop experiment explained - Implications of tawhid for muslim belief - What fraction is halfway between 1 4 and 3 8 - Solidworks diameter dimension centerline - Partial fraction decomposition worksheet with answers - Explain the biblical mandate for apologetics - Anton rosicky - Vnu business publications bv - Case studies - Mythbusters coke and mentos - How to make black powder without sulfur - Nursing - Getta byte software resource allocation - Eccles vets bowling league - Writing Assignment Instructions - Disney's design case study answers - Similarities between Christianity and Islam - Poetry terms study guide - George ritzer sociological theory pdf download - Discussion On AG Lafley Strategy Theories Options Menu: Forum - Contactcentre mycsp co uk - Contributing pigment in hair color - Psyc final essay outline - Beijing latitude and longitude - Project management conveyor belt project - Only connect em forster - Carbonic acid and strontium hydroxide - Bimanual palpation of kidney - 2018 business management exam - Diffusion experiment potassium permanganate - Catastrophic bleed palliative care - Linux - Active learning template growth and development infant - International law - Tigh nan saor plockton - Which type of targeting strategy is zipcar pursuing - 0.007 in scientific notation - Probation and Parole 1 discussion - Caribbean social studies worksheets - How to Get Assignment Help - Mole practice worksheet answers - Sociology - Bad visual aid examples - Accounting process is correctly sequenced as - Dr jessica hohman cleveland clinic - John kotter's 8 step plan for implementing change - Prologue of romeo and juliet - Arizona science teachers association - Montana 1948 key events - Careskills academy care certificate - What potential difference is needed to accelerate a - Rasilaben kalubhai savaliya book - How many combinations with 3 numbers 1 3 - Week 2 Disscussion Again - Boyle's law problems worksheet - Discussion Oct 20th - Mystery powder lab answer key - What are some of the major security threats caused by illegal immigration? - Creating Visio Data Models and Designs Using Visio - Week 10 discussion - Intrinsic and extrinsic risk factors - Magic whiteboard dragons den - Howl of the werewolf - Chipotle eastern and russell - Refer to figure 11-1. the marginal product of the 7th worker is - Where is the love by - Classification Model - Labor Relations and Collective Bargaining - In the hall of the mountain king instruments - How to respond to an osha complaint letter - Algebraic expression for 3 less than a number - Select one network scanning software tool and explain in detail how it works and how detects network vulnerabilities. Provide the site where you obtained your information and include that in your assignment write-up. - 3 bit binary counter truth table - Tarasoff vs regents university california brief - Ata paint technician online test - Journal entry for deferred tax asset valuation allowance