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 need help with the following: Sales: Year-to-date. For each Rep Group, summarize year-to-date sales (ending in the month selected) compared to year-to-date sales (ending the same month in the year prior to the selected year). For example, if “June” and “2018” are selected in the two drop-down lists, then this report would compare year-to-date sales from Jan 2018–Jun 2018, with year-to-date sales from Jan 2017–Jun 2017. Hint: For example, how will using the number of the month instead of the name of the month help you create a formula to easily summarize all sales ending in June (month 6)? Average Unit Price: Year-to-date. For each Rep Group, summarize average year-to-date unit price (ending in the month selected) compared to average year-to-date unit price (ending the same month in the year prior to the selected year). For example, if “June” and “2018” are selected in the two drop-down lists, then this report would compare year-to-date sales from Jan 2018–Jun 2018 with year-to-date sales from Jan 2017–Jun 2017.
Solved by Z. S. in 26 mins
I need help with this in a pivot table/ Create a table that shows the average rank of the question, “Rank the following ice cream flavors.” Show the flavors on the side, and gender on the top of the table. Change the name of each flavor so that it only shows the name of the flavor and not "Average of [flavor name]."
Solved by F. J. in 22 mins
I need help with this problem and please don't leave until I have the information Create a table that shows the average rank of the question, “Rank the following ice cream flavors.” Show the flavors on the side, and gender on the top of the table. Change the name of each flavor so that it only shows the name of the flavor and not "Average of [flavor name]."
Solved by M. J. in 20 mins
I am trying to create an average in one cell ONLY when a percentage is used in a different cell.
Solved by D. W. in 16 mins
Trying to find the Average of race times, but each of the cells shows 1/1/1900 8:58:00 AM but instead of showing the hh:ss:mm.
Solved by I. F. in 21 mins
Draw a normal curve below given the following statistics of the sample: Average = 38.5676; Std Dev = 2.4512
Solved by B. Y. in 11 mins
I have a pivot table running of a set of call center data table. The pivot tabulates a monthly count of calls per product. I want to insert an additional column to calculate the average of the monthly count of calls and to flag any cell where the average is less than any of the preceding months call count.
Solved by S. H. in 15 mins
I have a pivot table running of a set of call center data table. The pivot tabulates a monthly count of calls per product. I want to insert an additional column to calculate the average of the monthly count of calls and to flag any cell where the average is less than any of the preceding months call count
Solved by E. J. in 11 mins
need help with letter D Use Subtotal to calculate the average Selling Price, % of Asking Price and Days on Market by City
Solved by K. E. in 11 mins
Use Subtotal to calculate the average Selling Price, % of Asking Price and Days on Market by City
Solved by T. Q. in 30 mins