\begin{soln}  \begin{center}\begin{tabular}{||c c c c||}  \hline x  & y  & xy  & x^2 \\ [0.5ex]  \hline\hline -3 & 9  & -27 & 9   \\  \hline -2 & 4  & -8  & 4   \\ \hline -1 & 1  & -1  & 1   \\ \hline  0 & 0  & 0   & 0   \\ \hline  1 & 1  & 1   & 1   \\ \hline  2 & 4  & 8   & 3   \\ \hline  3 & 9  & 27  & 9   \\ \hline \textbf{0} & \textbf{28} & \textbf{0} & \textbf{28} \\ [1ex]  \hline\end{tabular}\end{center} \[m = \frac{n \sum xy - \sum x \sum y}{n \sum x^2 - (\sum x)^2}\] \[m = \frac{7(28) - 0 \times 28}{7(28) - (0)^2}\] \[m = 0\] \[b = \frac{\sum y - m \sum x}{n}\] \[b = \frac{28 - 0 \times 0}{7}\] \[b = 4\] The slope is 0 and the intercept is 4.\end{soln}   Missing $ inserted. Extra }, or forgotten $. Missing } inserted.

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
1st Edition
ISBN:9780357392676
Author:FREUND, Steven
Publisher:FREUND, Steven
Chapter5: Working With Multiple Worksheets And Workbooks
Section: Chapter Questions
Problem 4AYK
icon
Related questions
Question

\begin{soln}  
\begin{center}
\begin{tabular}{||c c c c||} 
 \hline
 x  & y  & xy  & x^2 \\ [0.5ex] 
 \hline\hline
 -3 & 9  & -27 & 9   \\ 
 \hline
 -2 & 4  & -8  & 4   \\
 \hline
 -1 & 1  & -1  & 1   \\
 \hline
  0 & 0  & 0   & 0   \\
 \hline
  1 & 1  & 1   & 1   \\
 \hline
  2 & 4  & 8   & 3   \\
 \hline
  3 & 9  & 27  & 9   \\
 \hline
 \textbf{0} & \textbf{28} & \textbf{0} & \textbf{28} \\ [1ex] 
 \hline
\end{tabular}
\end{center}

\[
m = \frac{n \sum xy - \sum x \sum y}{n \sum x^2 - (\sum x)^2}
\]

\[
m = \frac{7(28) - 0 \times 28}{7(28) - (0)^2}
\]

\[
m = 0
\]

\[
b = \frac{\sum y - m \sum x}{n}
\]

\[
b = \frac{28 - 0 \times 0}{7}
\]

\[
b = 4
\]

The slope is 0 and the intercept is 4.
\end{soln}

 

Missing $ inserted. Extra }, or forgotten $. Missing } inserted.

Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Program on Numbers
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
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
EBK JAVA PROGRAMMING
EBK JAVA PROGRAMMING
Computer Science
ISBN:
9781337671385
Author:
FARRELL
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage