topic Re: Needing Help with Linear Regression For Only Specific Values in Statistical Procedures

Needing Help with Linear Regression For Only Specific Values

pauliet987 — Tue, 20 Dec 2022 16:57:13 GMT

Hello,

I need assistance with a linear regression code I am working. Essentially, I am trying to predict how many positive cases will occur the next week based on number of labs performed in previous weeks. Example:

Week_Start Laboratory. Labs_Performed Number_of_Positive_Cases

11/04/2018. Lab1. 230 31

11/04/2018. Lab2. 300. 40

11/11/2018. Lab1. 260 45

11/11/2018. Lab2. 325. 46

I have a lot more variables than this. How would I go about doing a linear regression for just lab1 values and another linear regression with just lab2 values for the next week (week start 11/18/2018)?

Thank you for any help you can give!

Re: Needing Help with Linear Regression For Only Specific Values

PaigeMiller — Tue, 20 Dec 2022 17:49:51 GMT

@pauliet987 wrote:

Hello,

I need assistance with a linear regression code I am working. Essentially, I am trying to predict how many positive cases will occur the next week based on number of labs performed in previous weeks. Example:

Week_Start Laboratory. Labs_Performed Number_of_Positive_Cases

11/04/2018. Lab1. 230 31

11/04/2018. Lab2. 300. 40

11/11/2018. Lab1. 260 45

11/11/2018. Lab2. 325. 46

I have a lot more variables than this. How would I go about doing a linear regression for just lab1 values and another linear regression with just lab2 values for the next week (week start 11/18/2018)?

Thank you for any help you can give!

I think some clarification would be helpful.

Are you trying to predict the number of positive cases for 11/18/2018 using just labs performed in the week of 11/11/2018? Or does the prediction depend on both 11/04/2018 and 11/11/2018? How far back in time do we use the number of labs performed to get a prediction?

Why linear regression and not some sort of time series?

Re: Needing Help with Linear Regression For Only Specific Values

pauliet987 — Tue, 20 Dec 2022 18:00:58 GMT

I am trying to predict the number of positive cases from all the previous weeks labs performed. This would go back about 6 months.

Re: Needing Help with Linear Regression For Only Specific Values

PaigeMiller — Tue, 20 Dec 2022 18:27:06 GMT

@pauliet987 wrote:

I am trying to predict the number of positive cases from all the previous weeks labs performed. This would go back about 6 months.

This seems like a time series model, rather than a linear regression. To perform a linear regression, the number of previous weeks used in the prediction would have to be the same for every record, and that is not the case, based on your statement above.