# Get instant live Excel expert help to learn how to create a statistical function in Excel?

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

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

I am trying to get a column of percentage (GRADES) using the COUNTIF function to excel count cells with value or 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
I need to find the average weekly and per post "organic" reach and engagement. Amount of posts per week vary.
Solved by D. U. in 11 mins
I need to do a weekly average for reach and engagement
Solved by C. H. in 26 mins
I need to know the formula as to average the individual GREEN, RED, and BLUE cell data together in the TOTAL GREEN, RED, and BLUE cell at the bottom that have data in the cells. So, if there is no data in the individual cells the AVERAGE formula ignores these cells, and only averages the ones with numbers. There is not a specific 'range' for this, but the individual cells for each color that needs to be AVERAGED.
Solved by O. B. in 23 mins
I contacted you yesterday about average function excel 2010, and for real numbers it works fine, but I tried to get the expert to explain to me how to use the =AVERAGE function when the cells have formulas in them that generate '0' value, so the AVERAGE function would ignore these cells in the averaging method, but got no answer. So, I need to know how use the =AVERAGE function so that when there are formulas in the selected cells to average, that EXCEL would ignore those cells like they have real numbers in them, which seems to work fine. Please advise...
Solved by C. J. in 14 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
formula to find the biggest loss and win the average lose and win total wins all for the specific stock based on all my data Thanks
Solved by K. C. in 15 mins
First, average time between dates, signup date and 1st trip date. Second, what percent of drivers have >1 trip? Third, what is the estimated LTV?
Solved by B. H. in 25 mins
I need help with this In addition, the dashboard should have two more sections in it. The first section should be a Yearly dashboard view. In it, we want a drop-down list that allows us to choose one of the years in the worksheet. When we choose one of the years, we want to see: (a) the total revenue, (b) the average monthly revenue, (c) the maximum monthly revenue, and (d) the minimum monthly revenue for all historical sales that occurred in the selected year. I already have a ptable made or whatever it is called.
Solved by E. E. in 18 mins
We are creating a new customer classification system to focus on our largest customers. Our biggest customers are going to be called “Gold” class customers and the next group will be called “Silver” class customers: “Gold” class customers are those whose average monthly sales for the last twelve months are \$7,000 and greater or the average previous quarter sales are \$7,000 and greater. “Silver” class customers are those whose average monthly sales for the last twelve months are between \$2,000 and \$7,000 or the average previous quarter sales are between \$2,000 and \$7,000. Add a column next to the average monthly sales on the AR Aging sheet called “class” and make the word “Gold”, “Silver”, or blank appear as explained above. HINT: Do not try to do this step with Conditional Formatting. Now format these three columns: (1) Customer #, (2) the Customer Name, and (3) Class. Format all of these columns with gold fill and white font for the "Gold" class customers, and silver fill and white font for the “Silver” class customers. On the aging report, add our company’s logo (your choice of an appropriate logo), put a useful title on the report, add a freeze pane, and follow all Standards of Professionalism (only for the AR Aging report). The Standards of Professionalism are described in this list . You can also review this video tutorial to watch an explanation of the Standards of Professionalism.
Solved by B. D. in 12 mins