Question: Using the Excel spreadsheet provided in this week's lesson with energy data regarding temperature, electric use, electric cost, gas use, and gas cost for 19

  1. Using the Excel spreadsheet provided in this week's lesson with energy data regarding temperature, electric use, electric cost, gas use, and gas cost for 19 months, make a scatter plot with titles comparing gas use and gas cost as explained in the Week 5 presentation in slides 9-14. Make the x-axis "gas use" and the y-axis "gas cost".Copy and paste the scatter plot here:

  1. What is the Pearson r value for these two variables (do not round the answer)?

  1. What is the statistical significance (two-tailed p value) for these two variables (do not round the answer)?

  1. What is the regression equation for the relationship between these two variables?

  1. Using the same Excel spreadsheet, make a scatter plot with titles comparing temperature and gas use. Make the x-axis "temperature" and the y-axis "gas use". (You may find it easiest to first delete the two intervening columns in the spreadsheet.)Copy and paste the scatter plot here:

  1. What is the Pearson r value for these two variables (do not round the answer)?

  1. What is the statistical significance (two-tailed p value) for these two variables (do not round the answer)?

  1. What is the regression equation for the relationship between these two variables?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Q:

Avg Temp Elec Use Elec Charge ($) Gas Use Gas Charge ($) 75 1589 177.55 22 29.25 72 920 107.21 15 22.50 67 699 83.00 9 16.59 52 704 83.31 64 76.04 46 807 90.28 96 112.08 32 904 99.35 155 181.96 28...

Q:

(i) Write down the linear program relaxation for the vertex cover problem and solve the linear program. [6 marks] (ii) Based on the solution of the linear program in (b)(i), derive an integer...

Q:

Let r and s be solutions to the quadratic equation x 2 b x + c = 0. For n N, define d0 = 0 d1 = r s dn = b dn1 c dn2 (n 2) Prove that dn = r n s n for all n N. [4 marks] (b) Recall that a commutative...

Q:

3 COLLEGE ALGEBRA - TRIGONOMETRY Business and Finance (MAT115) This course will start with a review of basic algebra (factoring, solving linear equations, and equalities, etc.) and proceed to a study...

Q:

The case discusses the dilemma of the CFO of PSUWC Energy LLC, an energy generating firm, who needs to present his recommendation to the company Board regarding a proposed investment in a new...

Q:

Need help with this assignment.I've attached the excel workbook that should be used to record answers and the case scenario. The case discusses the dilemma of the CFO of PSUWC Energy LLC, an energy...

Q:

Scenario: Tom Jones, the CFO for the firm PSUWC Energy, LLC, woke up with a start at 4:00 am on 04/27/2018, due to his phone ringing. It was his senior financial analyst, vacationing in Europe,...

Q:

FIN 301: Penn State World Campus Final Excel project Scenario: Tom Jones, the CFO for the firm PSUWC Energy, LLC, woke up with a start at 4:00 am on 6/19/2018, due to his phone ringing. It was his...

Q:

PLEASE COMPLETE NO LATER THAN 10/07 @8:00AM Each question(1,2,& 3) must be a minimum of 200 words. Please make answers detailed and knowledgeable based off the attached reading. ARE YOU ABLE TO...

Q:

Please see attachment. All three question need to be answered in narrative format. If you have questions, just let me know. Normal requirement for references are 2 outside our course text....

Q:

1. Palestrina, kyrie from pope marcellus mass, weelkes, as vesta was descending, morley, now is the month of maying, gabrieli, plaudite, compare and contrast these two forms from the renaissance....

Q:

Nesmith Corporation is considering two alternatives: A and B. The costs associated with the alternatives are listed below: Alternative A Alternative B material costs $39,000 $50,000 processing costs...

Q:

Customer service impacts demand with the impact being very product specific. true or false

Q:

What are the key elements of the scientific method and how does this method relate to economic principles and laws?

Q:

LaTanya Corporation is planning to issue $100,000, seven-year, 8 percent bonds. Interest is payable each December 31. All of the bonds will be sold on January 1, 2011. Required: Compute the issue...

Q:

What is meant by the term utility and how does the idea relate to purposeful behavior?

Q:

Company ABC is considering using off-balance-sheet financing in order to obtain a loan from a local bank, but the company is unsure of the various forms of off-balance-sheet financing. For...

Q:

Mr. Ned Newell is employed by Snoopy-Snacks Ltd. (a Canadian-controlled private corporation). As of February 15, 2012, Ned was promoted to vice-president sales due to his hard work negotiating puppy...

Q:

Design a minimum-mass symmetric three-bar truss (the area of member 1 and that of member 3 are the same) to support a load P, as was shown in Fig. 2.9. The following notation may be used: Pu = P cos...

Q:

Jerry Wong, your boss at Office Ease Solutions, has discovered that some of his colleagues find his e-mails too harsh, while others sometimes feel his e-mails are unprofessional. Jerry thought he was...

Q:

Creating your own resume takes a great deal of time and effort. You need to gather the information you plan to include in the resume and then organize this information according to the ASCENT...

Q:

In your role as assistant to Teresa Sanchez, the office manager at Prism Event Planning in Albuquerque, you are responsible for writing memos to keep the companys event planning consultants informed...