Question

Starting from a blank spreadsheet, create a macro that: Is named "MyMacro" Is invoked with CTRL-SHIFT-L Asks the user for the number of uniforms [0,1] observations to generate. Valid responses are between 10 and 100, inclusively. Generates the appropriate number of observations in column A, starting at A1. In cell B1, display the mean of the observations. In cell B2, display the standard deviation of the observations

Answer 1

Record Macro Macro name: MyMacrol Shortcut key Ctri Shift+L Store macro in This Workbook Description: Click below record macro button and do as shown above in the record macro tab Remember to press shift before writing l

VBA code below:

Sub MyMacro()

MYVALUE = InputBox("enter number between 10 to 100")
If MYVALUE < 10 Or MYVALUE > 100 Then
MsgBox "Please enter value between 10 to 100"
Else
ActiveCell.FormulaR1C1 = "=RAND()"
For i = 1 To MYVALUE
Cells(i, 1) = "=RAND()"
Next i
End If
Range("B1").Select
ActiveCell.FormulaR1C1 = "=AVEDEV(C[-1])"
Range("B2").Select
ActiveCell.FormulaR1C1 = "=STDEV.P(C[-1])"
End Sub

Copy paste the above part in MyMacro

Parekn, Kunjesh Sort & nd&hare Web Check Cell Linked Cell Inset Delete Tormst きQear Furmalling Tabe enter number betwzen 1u to 10 Cancel Sheet 。lype here to search

Hope the above answer has helped you in understanding the problem. Please upvote the ans if it has really helped you. Good Luck!!