Week (X)Demand (Y)120002220031890422485190262300723048190391899102180111893121201131000how do I insert a linear trendline and be sure to display the equation and R value in excel?

The given data is: Week (X) Demand (Y) 1 2000 2 2200 3 1890 4 2248 5 1902 6 2300 7…

Answered: Week (X) Demand (Y) 1 2000 2 2200 3…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

The following linear regression model can be used to predict ticket sales at a popular water park. Ticket sales per hour = - 631.25 + 11.25(current temperature in °F)23) Choose the statement that best states the meaning of the slope in this context. A) The slope tells us that a one degree increase in temperature is associated with an average increase in ticket sales of 11.25 tickets. B) The slope tells us that high temperatures are causing more people to buy tickets to the water park. C) The slope tells us that if ticket sales are decreasing there must have been a drop in temperature. D) None of these
Please help
Data contains brain mass in different species versus glia-neuron ratio, the latter being a measurement of brain metabolism as the glia provides the metabolic needs of the neurons. The relationship between THE LOGARITHM of the brain mass (in the third column) and Glia-neuron ratio (fourth column) appears linear and it is these two variables that we wish to analyze via linear regression. We would like to know if the human brain fits the trend from the other species. Towards this end we will perform the regression on all species EXCEPT humans (Homo sapiens). Again, throw out the human data from your analysis. You will however need the human numbers for some of the questions. What is the coefficient of determination (R2) for the data? What is the standard error of the slope of the regression line (SEb) ?
Data was collected for a regression analysis comparing car weight and fuel consumption. b0 was found to be 32.7, b1 was found to be -7.6, and R2 was found to be 0.86. Interpret the y-intercept of the line. On average, each one unit increase in the weight of a car decreases its ful consumption by 7.6 units. On average, when x=0, a car gets -7.6 miles per gallon. On average, when x=0, a car gets 32.7 miles per gallon. On average, each one unit increase in the weight of a car increases its fuel comsumption by 32.7 units. We should not interpret the y-intercept in this problem.
Pre Calc Direct and Inverse Variation
I need the right answer to a and b.

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS

Week (X)	Demand (Y)
1	2000
2	2200
3	1890
4	2248
5	1902
6	2300
7	2304
8	1903
9	1899
10	2180
11	1893
12	1201
13	1000

Week (X) Demand (Y) 1 2000 2 2200 3 1890 4 2248 5 1902 6 2300 7 2304 8 1903 9 1899 10 2180 11 1893 12 1201 13 1000 how do I insert a linear trendline and be sure to display the equation and R value in excel?