Complete the table below by finding the squares of each of the x-values (for example, if x1 = 5, then x12 = 52 = 25). After you have all five x2 values calculated, add them up and indicate the sum in the bottom row.    Temperature (°C) x Solubility (g/100mL) y   x2   10 31     20 33     30 37     40 41     50 42   Sums:     Complete the table below by finding the squares of each of the y-values (for example, if y1 = 10, then y12 = 102 = 100). After you have all five y2 values calculated, add them up and indicate the sum in the bottom row.    Temperature (°C) x Solubility (g/100mL) y   x2   y2   10 31       20 33       30 37       40 41       50 42

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter7: Developing An Excel Application
Section: Chapter Questions
Problem 3RA
icon
Related questions
Question

 

 

You may find it useful to have a spreadsheet open where you can write down these values in a larger table to help keep track.

Complete the table below by finding the squares of each of the x-values (for example, if x1 = 5, then x12 = 52 = 25). After you have all five x2 values calculated, add them up and indicate the sum in the bottom row. 

 

Temperature (°C)

x

Solubility (g/100mL)

y

 

x2

 

10

31

 

 

20

33

 

 

30

37

 

 

40

41

 

 

50

42

 

Sums:

 

 

Complete the table below by finding the squares of each of the y-values (for example, if y1 = 10, then y12 = 102 = 100). After you have all five y2 values calculated, add them up and indicate the sum in the bottom row. 

 

Temperature (°C)

x

Solubility (g/100mL)

y

 

x2

 

y2

 

10

31

 

 

 

20

33

 

 

 

30

37

 

 

 

40

41

 

 

 

50

42

 

 

Sums:

 

 

 

 
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Graphical User Interface
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning