Question

Comments	Likes
46,391	309,000
1,095	8,300
12,140	121,000
6,517	110,000
80,203	872,000
5,248	18,000
9,733	159,000
3,894	108,000
9,078	154,000
5,265	14,000
1,589	9,800
36,895	555,000
8,062	41,000
6,261	45,000
4,846	111,000
4,016	13,000
4,671	7,400
5,280	53,000
14,235	56,000
14,324	8,900

1. Explain what your project is about.

1. How did you collect your data? Why is it a good representation of the relationship between the two variables?

1. Use Excel to create a least squares equation.

1. Use Excel to get a regression readout. Is there a relationship between the variables? Explain.

1. What is the slope of your least squares equation and what does it tell you?

1. What is the 95% confidence interval given in the Excel readout for your independent variable? What does it tell you?

1. Find the r-square value. What do this value tell you?

1. Show one example using your least squares equation to calculate and predict a value for the dependent variable. (This is similar to what I did in my example when I used the equation to predict the cost for a home with 3500 sq ft.)

1. Create a 95% confidence interval for the mean value of y and a 95% prediction interval for an individual new value of y and interpret these intervals.

Answer 1

Dear student, we can provide you with the solution of 4 sub question at a time.

We will run the regression analysis here

1) The project is about finding the relationship between the number of comments and number of likes on a week old post on a American celebrity Instagram account.

2)( Though this one should be answered by you yourself) We collected the data from Instagram

By randomly selecting the American celebrity and then randomly selecting a week old post and noting the number of likes and comments

3)

4) The slope of the regression line is 10.4788, which tels that for every increase in the number of comment, the numbers of likes on a week-old post on an American celebrity Instagram account increases by a factor of 10.4788

5) the 95% confidence interval given in the Excel readout for the independent variable is (8.5021,12.4554).

It tells that we are 95% confident that the slope of the regression line which is the coefficient of the independent variable in the regression line will lie within the interval (8.5021,12.4554).

6) This means that 87.33% of the variation in the numbers of likes on a week-old post on an American celebrity Instagram account can be explained by the number of comments.

7) for number of comments 12000 on a post

number of likes is