Press Ctrl+Shift+Enter to calculate the array formula.The second argument is the range of temperatures and rainfall. The first argument is the range of known sales figures. LINEST is going to return three values, so select a range of three cells that are side by side.The LINEST function can return the values M1, M2, and b that best describe your sales model. After a multiple regression, you will have a formula that predicts sales like this: Strategy: You need to do a multiple regression. I set up the table below, which shows each day's sales, temperature, and whether it rained.īased on the data I've collected, how can I determine the relationship between sales, temperature, and rainfall? On rainy or cool days, fewer people buy gelato. As I analyzed sales, I began to feel that temperature and rain might be two important determining factors in how much money I make. After 10 days of sales, I discovered that each day, I would either make a lot of money or nearly go broke.
0 Comments
Leave a Reply. |