For an accounting pexpert or excel information systems expert. Please show me how to solve each one of these stepsd below in excel. I would like an indepth step by step including which tools to you on excel and how to apply them. Thank you. Start Excel. Download and open the downloaded file named Excel$\_$Ch$12\_$Prepare$\_$Statistical$\_$Analyses$\_$ PartA.xlsx$.$ Grader has automatically added your last name to the start of the filename. Save the file to the location where you are storing your files. $0$

$2$ Randomness in selecting a sample from a population is crucial in conducting effective and accurate statistical analyses. The RAND function in Excel is one method that can help in creating a random sample.

On the RandomSample worksheet, use the RAND function to generate $34$ random values. Start your calculations in cell B$3$ and copy the function down to B$36.$ Sort the data in ascending order. Select the range A$3$:A$12.$ Copy the selected values and paste the to cells E$3$:E$12.10$

$3$ Excel has many built$-$in functions that can be used to conduct basic statistical analysis on data. Knowledge of how to use even the most basic statistical functions can increase your understanding of the data and enable better decision making.

Navigate to the BasicStats worksheet. Use the data provided in column C to calculate the mean, median, and mode. Place the mean calculation in cell G$2,$ the median in cell G$3,$ and the mode in cell G$4.10$

$4$ Calculating the range, variance, and standard deviation of a data set is used to determine the dispersion of a data set. Knowing how a data set is dispersed can provide a better understanding of the data than the mean, median, and mode alone.

Using the data on the BasicStats worksheets and in column G$,$ calculate the range, variance, and standard deviation of the random sample data set in order to understand how the data is distributed. Place the minimum in G$6,$ the maximum in G$7,$ the range in G$9,$ the sample variance in G$10,$ and the sample standard deviation in G$11.10$

$5$ A box and whisker chart provides an efficient method of visualizing the distribution of your data and highlights outliers as part of the chart.

Visualize the distribution of the quantities sold in the random sample of data for which you previously calculated statistics. Using the data in cells B$1$:C$35$ create a Box and Whisker chart. Change the chart title to Distribution of Orders and move the chart so that it covers cells I$2$:P$15.12$

$6$ The FREQUENCY function in Excel is an array function that creates a frequency distribution that calculates how often values occur within a bin. An array function can perform multiple calculations on one or more items in an array. Array functions look different from other functions because curly brackets $\{\}$ are required for the function to calculate correctly.

On the OrderDistribution worksheet use the FREQUENCY array function to group the number of cases ordered into the bins provided in column D$.$ Place the calculations in cells E$2$:E$6$ and add the label More in D$6.10$

$7$ The Data Analysis add$-$in allows you to conduct a variety of statistical analyses with ease. For example, instead of typing out individual functions to calculate the mean, median, mode, variance, and standard deviation, you can generate all of those and more using the Analysis ToolPak.

Install the Data Analysis add$-$in to analyze the data on the DescriptiveStats worksheet. Generate descriptive statistics on the data in cells B$1$:B$13.$ Use the Label in cell B$1$ and use cell E$1$ as the Output cell for the statistics. Resize the columns as needed. $10$

$8$ A histogram is a statistical graph that summarizes the distribution of data and how the data fits into defined bins.

On the Histogram worksheet, create a histogram to visualize the distribution of data in cells A$1$:B$31.$ Change the number of bins in the histogram to $10$ and type Histogram of Items Purchased for the chart title. Move the histogram to cover cells E$4$:K$18.12$

$9$ Moving averages can be useful in spotting trends over a period of time by smoothing out any fluctuations that may occur during each consecutive interval. Moving average data can be used to create charts that show whether the value is trending upward or downward.

On the MovingAverage worksheet, calculate a moving average for every three months to determine whether there is an upward or downward trend over the course of the year. Open the Data Analysis ToolPak, select Moving Average, and use the data in B$2$:B$13$ as the Input Range. Use $3$ as the interval and C$2$ as the Output Range. Include a chart in the output and edit the chart title to Moving Sales Average. Edit the vertical axis label to read Sales. $26$

$10$ Save the workbook, exit Excel, and then submit your file as directed.

Please note: This project continues in part B$,$ which can be found in the Product Shared Library.