Hello,       I need help getting a geometric mean for all values on every date. For instance:   Date:                     Patients           Value 01/02/2023.           1                       3 01/02/2023.            2                     4 01/05/2023             1                      6 01/05/2023             2                       7 01/05/2023             3                      8    What I want: Date:                   Geometric Mean: 01/02/2023        3.46 01/05/2023        6.95   Thank you for any help you are able to provide!  ... View more

Hello,  I am trying to make an Arima Model to predict how many positive cases will occur the next week based on all previous number of labs performed in previous weeks Example:   Week_Start     Labs_Performed  Number_of_Positive_Cases 11/04/2018.         230                        31 11/11/2018.             260                    45   There is about 6 months worth of data but all put into a weekly format. How do I make an arima model to accomplish this. Thank you for any help you can give!  ... View more

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!  ... View more

Hello, I need assistance merging two different data sets together. The two datasets look like this:   HAVE1 Week_Start   Hospital   Samples    Average 07/05/2020.   Name1.   2.               2 07/05/2020.   Name2.   3               3 07/05/2020.   Name3.   1.              1 07/12/2020.   Name1.   2.               2 07/12/2020.   Name2.   3               3 07/12/2020.   Name3.   1.              1   Have2 Week_Start    Hospital.   Cases 07/05/2020.    Name1.     10 07/12/2020.   Name1.      25   What I want is to merge the datasets to add the cases column specifically for Hospital Name1. For example, what I WANT; Week_Start   Hospital   Samples    Average.  Cases 07/05/2020.   Name1.   2.               2.              10 07/05/2020.   Name2.   3               3.                -- 07/05/2020.   Name3.   1.              1.                -- 07/12/2020.   Name1.   2.               2.             25 07/12/2020.   Name2.   3               3.             -- 07/12/2020.   Name3.   1.              1.             --     Thank you so much for any help you can provide! ... View more

Hi everyone,      I need some assistance with combining variables to create a new variable. What I HAVE: Zipcode Week_Start.  Facility 88888.   4/7/2019.      1 77777.   4/7/2019.       1 88888.   4/7/2019.        1 66666.   4/7/2019.        2 55555.   4/7/2019.        3 77777.   4/14/2019.       1 88888.   4/14/2019.        1 66666.   4/14/2019.        2 66666.  4/14/2019.         2 55555.   4/14/2019.        3   Some Zipcodes are different (i.e. 77777 and 88888), but they are still associated with the same Facility. I want to be able to get a count of Zipcodes associated with each facility for each week_start. For example, what I WANT:   Week_Start.  Facility.  Count 04/07/2019.   1.          3 04/07/2019.    2.         1 04/07/2019.   3.           1 04/14/2019.  1            2 04/14/2019.   2.          2 04/14/2019.  3.           1   Thank you for any help you are able to provide!  ... View more

Hello,      I am trying something I have never done before, and I can't get it right. Essentially, I have a bunch of Zipcodes associated with a particular Week_Start date. For example,   What I have  Zipcode    Week_Start 04662.       02/27/2018 14738.       02/27/2018 04662.        02/27/2018 14738.        03/06/2018 04662.        03/06/2018 04662.        03/13/2018 14738.        03/20/2018   What I want to do is sum the total observations of Zipcodes for a particular Week_Start. For example,   What I want: Total_ZipCodes Week_Start  3                         02/27/2018 2.                         03/06/2018 1                          03/13/2018 1                          03/20/2018   Thank you so much for any help you are able to give!    ... View more