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

I am currently trying to make a line graph based on a pivot table of data. I have two main issues:
1) Currently, my x-axis is Date, and it extends from January to December, just the months, no corresponding year. However, my data spans from September 2016 to December 2017, and so data points for the Fall, say, Oct 2016 and Oct 2017 are overlapping each other over the "October" tab on the x-axis. I want an X-axis that spans from September 2016 to December 2017.
2) I made two pivot tables from this data set: one for averages, and one for standard deviations. I want to figure out how to make a line graph from both so that I plot the value averages (as desired in Problem #1) and have corresponding standard deviation error bars for each data point.

Solved by A. H. in 15 mins

Considering all realtors, find the standard deviation of dividing the realtor's zip code by their number.
This is assuming that the file may extend to thousands of rows.

Solved by C. H. in 27 mins

You are a financial analyst for Williamston Widgets, Inc. The company’s 401(k) provider, the National Bank of Southeast Haslett, has been fired by your CEO for not providing adequate reports to plan participants. She has entrusted you with putting together a workbook with a dashboard that has the following features:
1. A table of all of the 401(k) plan’s available mutual funds, sorted by asset class and style category, that shows the following data points: Fund name, ticker symbol, style category, standard deviation, category rank for the past 1, 3 and 5 years, and expense ratio.
2. Create a Combo Box that contains each available fund, and displays the following data for the fund along with its category average: Fund name, ticket symbol, style category, performance for the past 1, 3 and 5 years, standard deviation, and expense ratio.

Solved by K. H. in 17 mins

1. Separate the sample into Male and Female employees.
2. Create confidence intervals assuming the population variances are not equal but unknown
3. Create confidence intervals assuming the population standard deviation of male Fast employee salaries is $28,000.00 and that the population standard deviation of female Fast employee salaries is $29,000.00

Solved by K. J. in 27 mins

Create confidence intervals assuming the population standard deviation of male Fast employee salaries is $28,000.00 and that the population standard deviation of female Fast employee salaries is $29,000.00.

Solved by D. D. in 28 mins

Need a formula to find standard deviation of returns of different stock tickers. Needs to be drag-able.

Solved by I. Y. in 30 mins

I need hel finding a formula to find standard deviation of returns of different stock tickers.

Solved by V. F. in 29 mins

Using a general formula that can be dragged down, determine standard deviation of returns in column Q, for each ticker. You will need to be creative in how you write a conditional format here. You will start with =Stdev.

Solved by Z. Y. in 28 mins

Need to add custom (not automatic) standard deviation bars in the excel mobile version. How do I do this?

Solved by M. H. in 28 mins

The amount of mayonnaise dispensed from a machine at The Fast Food Factory is normally
distributed with a mean of 0.85 g and a standard deviation of 0.1 g. If the machine is used
800 times, approximately how many times will it be expected to dispense 1 or more grams
of mayonnaise.

Solved by E. E. in 18 mins