Question: I don't understand how to use linear regression in Excel to estimate missing values. I understand how to use linear regression when the dataset is

I don't understand how to use linear regression in Excel to estimate missing values. I understand how to use linear regression when the dataset is complete but not without.

For example : Height & Weight, put there is one cell missing from both sets of data and I need to estimate them.

The missing data is highlighted in yellow and I need to use linear regression to find it.

I don't understand how to use linear regression in Excel to estimate

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!

Students are required to submit a Mini Project in the field of data science. The mini project will essentially involve working with a dataset to be imported from from either a CSV or Excel file....

make a e mini - project about ( National Rural Livelihoods Mission ) ( the data should be from"data.gov in " ) will essentially involve working with a dataset to be imported from either a CSV or...

data science. dataset from kaggle, title Youth Tobacco Dataset ( 2 Decades ) . . It is should to use the Pandas library and package in Python to work . The project will be divided into four main...

QUESTION 1 Although recent events in Hong Kong have created uncertainty, often such things can also provide opportunities for investors. As a first step, an investor considering the Hong Kong share...

Week 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68...

Logarithms and polynomials Interaction effects Dummy variables ECMT1020: Introduction to Econometrics Lecture 10: Multivar. regr. & transformations Peter Exterkate peter.exterkate@sydney.edu.au...

Month/Yr. Jan. 2016 PERIOD PRICE AIP 1 5.4 5.9 2 5.5 6.6 3 6.0 6.4 4 6.1 6.1 5 5.9 6.4 6 5.9 6.3 7 5.9 6.0 8 6.8 6.0 9 6.8 5.8 10 6.4 6.3 11 6.5 6.3 12 6.3 6.2 13 6.1 6.5 14 6.1 6.6 15 6.0 6.3 16 6.4...

9 17 4. 10 12 13 14 15 16 Enterprise Industries produces Fresh, a brand of liquid detergent. In order to more effectively manage its inventory, the company would like to better predict demand for...

The Fresh Detergent Case Enterprise Industries produces Fresh, a brand of liquid detergent. In order to more effectively manage its inventory, the company would like to better predict demand for...

Run Markdown NFL Play-by-play Modeling and Classification In [10] : import os import pandas as pd import numpy as np import seaborn as sb import statsmodels . api as sm import sklearn. tree as tr...

write 1500 words for the prompt as attached. You have to see the details and Tips, cite from the require reading and textbook as attached. See the details for class powerpoints for your argument....

Assume the same fields as in Problem 10.14 and show that Maxwell's equations in a source-free region can be written as From these equations deduce a k a E = a H and a k a H = a E k E = 0 k H = 0...

In the audit of accounts payable, an auditor may revise the risk of material misstatement based on the result of Blank _ _ _ _ _ _ .

How to calculate net cost of goods purchased? JKR Shop 225000 Beginning inventory Net Cost of goods purchased 802250 Goods available for sale 1027250 Cost of goods sold 700000 Ending inventory 327250