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

Option to choose data shown from legend in line graph

Solved by M. Q. in 14 mins

Create a dashboard sheet that allows the faculty member to choose one of the eight types of crops using option buttons. Note: the faculty member wants to select the crop using option buttons, not a drop-down list. When he selects a crop, the dashboard should summarize all relevant information for the selected crop, as well as how many of the selected crop he should plant in order to make as much profit as he can.

Solved by X. D. in 23 mins

: You must decide on the appropriate test for the difference between the two population means. In section 10.1, we learned about hypothesis tests for the difference between two population means when the population standard deviations are known; that procedure is the z-Test: Two Sample for Means in Excel’s Data Analysis tool. In section 10.2, we learned about hypothesis tests for the difference between two population means when the population standard deviations are unknown; that procedure is the t-Test: Two-Sample Assuming Unequal Variances in Excel’s Data Analysis tool. Choose the appropriate test for this scenario and complete the analysis in Excel. Step-by-step directions for each of these tests are at the end of the respective sections in the book.

Solved by G. C. in 30 mins

: You must decide on the appropriate test for the difference between the two population means. the difference between two population means when the population standard deviations are known; that procedure is the z-Test: Two Sample for Means in Excel’s Data Analysis tool. hypothesis tests for the difference between two population means when the population standard deviations are unknown; that procedure is the t-Test: Two-Sample Assuming Unequal Variances in Excel’s Data Analysis tool. Choose the appropriate test for this scenario and complete the analysis in Excel.

Solved by E. E. in 29 mins

I'm creating excel table design templates in excel.
One section of the template can be a number of different sheets (ex 5x10 cells, 10x10 cells, 15x10 cells etc)
I would like to have these options in the drop-down menu so that if they choose 5x10 then that table appears, or similarly if they choose 10x10 then that table appears.

Solved by C. C. in 24 mins

You are going to roll four twenty-sided dice. If the rolls total to 20 or less, roll two more twenty-sided dice and add that to the total. For instance, if the total of my four die rolls is 32, then that is the score of the game. If the total is 17, then I roll two more dice and add that to the total. If these two bonus dice total 20, then the score of that game is 37. Of ten thousand games, what is the average score? (choose the closest range)

Solved by F. A. in 26 mins

The below formula has a defined path '[TOC Model.xlsm]Partlist'!. This makes it choose a specific worksheet in a specific file. I need a vba code that can replace the hardcoded path with a user defines file chooser. The worksheet tab name (Partlist) remains the same
Range("B2").Select
Selection.FormulaArray = _
"=IFERROR(INDEX('[TOC Model.xlsm]Partlist'!R2C2:R10000C2,SMALL(IF(RC[-1]='[TOC Model.xlsm]Partlist'!R2C1:R10000C1,ROW('[TOC Model.xlsm]Partlist'!R2C1:R10000C1)-1),ROWS(R2C:RC))),"""")"
Selection.AutoFill Destination:=Range("B2:B5037")
Range("B2:B5037").Select

Solved by A. E. in 14 mins

Pls refer to the attached file. The macros code is on sheet 2.
I want the hardcoded path (highlighted in yellow) to be replaced by a code that prompts user to choose a file from the browser

Solved by C. A. in 26 mins

Pls refer to the attached file. The macros code is on sheet 2.
The formulas used in the attached excel uses a different workbook therefore a defined path to that excel workbook is hardcoded
I want the hardcoded path to be replaced by a code that prompts user to choose a file from the browser

Solved by E. W. in 23 mins

You are going to play a game where you bet a dollar and get to flip a coin ten times. If you get four heads in a row, you win. If you make the tenth flip without getting four heads in a row, you lose. Run this game ten thousand times. Approximately what is the probability that you will win? (choose the proper range)

Solved by T. S. in 19 mins