THE DATA IS IN THIS LINK: https://docs.google.com/spreadsheets/d/1d3O77eFR6yCAgM

Question

THE DATA IS IN THIS LINK: https://docs.google.com/spreadsheets/d/1d3O77eFR6yCAgMaxgQbtPRqv0y0TT8SupulIrl1C4eA/edit?usp=sharing

Need in VBA Excel   

Multiforms. Disregards the "documentation sheet" part in the instructions.

Link to Stats.xlsx:   https://docs.google.com/spreadsheets/d/1d3O77eFR6yCAgMaxgQbtPRqv0y0TT8SupulIrl1C4eA/edit?usp=sharing

VBA: Question 6: Create a multitab UserForm which has 2 tabs. Under a tab named Statistics and using the data found on the Stats.xlsx worksheet, allow the user to select the data and then display in a MsgBox these statistics: 1. The average of the selected data 2. The standard deviation of the selected data 3. The largest value in the selected data 4. The smallest value in the selected data 5. The median of the selected data Do not forget your run buttons and your documentation sheets

Explanation / Answer

1 ) To find average use excel function      =AVERAGE ( select your all the data )     and then hit on enter.

Average = 79.2

2 ) To find standard deviation, type in excel     =STDEV( select the data )    and then hit on enter.

Standard deviation =   12.161992

3 ) To find largest value type in excel      =MAX( selec the data )

Largest value = 97

4 ) To find smallest value type in excel    =MIN( select the data )

Smallest value = 51

5 ) To find median, type    =MEDIAN ( select the data )  

Median =   80.5

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.