“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I'm trying to figure out a formula that lets me find the 3rd character of a number within a certain date range and then take the total count and divide it by the total piece count to give me a % which reflects onto another sheet in that workbook. The formula I am using to find the 3rd character is =SUMPRODUCT(--(MID(I18:I500,3,1)="9")) and =SUMPRODUCT(--(MID(I18:I499,3,1)="8")). Here are some pictures that might help. I need the 3rd character in column "I" to be totaled and then divided by the total piece count "B4" to get a percentage that is reflected on Sheet "PDC Dashboard" in B57, C57, etc based on the date range those pieces are in.

Solved by A. A. in 21 mins

I'm using icon sets in conditional formatting, and the icons are appearing to be wrong based on the percentage.

Solved by I. C. in 12 mins

I'm just trying to figure out how to randomly generate numbers with a higher percentage for the chance of some of them?

Solved by I. Y. in 22 mins

I am trying to get a column of percentage (GRADES) using the COUNTIF function to count the number of cells with text, then SUM only those cells. Here's the formula I have so far, but it is not working; =COUNTIFS(C8:C41,"<>"&"",F8:F41,"AVERAGE")

Solved by M. E. in 30 mins

The accompanying dataset contains six years of quarterly sales from your store. You would like to forecast future sales as way to inform you as you make staffing and budgeting plans. Please answer all of the following questions. The dataset can be found here.
For numerical questions, answer with 4 digits to the right of the decimal.
Statistically test at the alpha=0.05 statistical significance level whether or not there exists a linear trend in the time series data. What is the p-value of your statistical test?
Based on your answer to the question above, can you conclude that a linear trend exists in this time series data (Y or N)?
=====
Regardless of you answer above, create a multiple linear regression model that captures both linear trend and additive seasonality. You should use Q4 as your base season and fit the model with all 24 data points.
All of the independent variables are statistically significant at the alpha=0.01 level (Y or N).
Which quarter (1, 2, 3, or 4) has the largest sales on average?
Which quarter (1, 2, 3, or 4) has the smallest sales on average?
What is the value of the Adjusted R-squared?
Using this multiple linear regression model, what is the value of the MAPE? (Please report it as a percentage with 4 digits to the right of the decimal and no percentage sign.)
Using this multiple linear regression model, forecast each quarter for the next year (2016). What is the forecast for Q3?
Carefully explain the how to interpret the value of the estimated coefficient on the time period index.
Carefully explain the how to interpret the value of the estimated coefficient on the variable representing quarter one.
=====
Using the same dataset as before, you now would like to add an exogenous variable as a possible explanatory variable to the model. This variable is in the column labeled ‘Ads – Lag 1’. This variable represents the number of advertising campaigns ran the previous quarter. (The thought is that the ads run last quarter affect the current quarter’s sales.)
Calculate the correlation coefficient between the variables ‘Ads – Lag 1’ and ‘Sales’. What is its value?
Continuing with this thought, now create a multiple linear regression model that captures both linear trend and additive seasonality. You should use Q4 as your base season and fit the model with all 24 data points. Additionally, add the variable ‘Ads – Lag 1` as an independent variable.
Is the variable ‘Ads – Lag 1` statistically significant at the alpha=0.05 level (Y or N)?
What is the value of the Adjusted R-squared value?
0.4699
Using this multiple linear regression model that captures trend and additive seasonality and the additional independent variable for advertising, what is the value of the MAPE? (Please report it as a percentage with 4 digits to the right of the decimal and no percentage sign.)
Using only the data that you have been given, can you make forecasts for the year 2016 using this model (Y or N)?
If your answer was “Y” above, then what is the forecast for Q1 of 2016. If it was “N”, explain why not.

Solved by A. J. in 18 mins

Hi, I have created a pivot table and want to create a calculated field representing the percentage of hospitalizations (hospitalizations divided by population). I am having trouble with this as the calculated field option is disabled. Please help! I am desperate

Solved by O. J. in 19 mins

hi please can you help me,
One of your colleagues helped me do a formula to increase my cost by 45%, is it possible to set the sheet up so I can increase the percentage if need be?
Is there any problem moving a sheet with formulas to another excel file?

Solved by O. H. in 20 mins

What percentage of signups (drivers) become active renters (i.e. >1 trip)? At what point in the user lifecycle are they most likely to activate (i.e. complete their first trip)?

Solved by E. E. in 28 mins

What percentage of signups become active renters? At what point in the user lifecycle are they most likely to activate (i.e. complete their first trip)?
Using this data, how would you estimate customer lifetime value?

Solved by V. J. in 27 mins

Previously I asked for my cost sheet to be margin up, when I go into the sheet to alter the percentage it does not apply the formula across all cells

Solved by V. D. in 27 mins