Commands For Statistical Procedures, Tests, And Chart 282904

Commands For Statistical Procedures Tests And Cha

Commands for Statistical Procedures, Tests, and Charts in Excel Mean: =AVERAGE(click and drag on cells); click “enter”. Median: =MEDIAN(click and drag on cells); click “enter”. Mode: =MODE(click and drag on cells); click “enter”. Range: (highest value – lowest value). There is no command for mode in Excel, so this needs to be done manually. Standard Deviation: =STDEV(click and drag on cells); click “enter”. Confidence Interval: =CONFIDENCE(alpha, standard deviation, size); click “enter”. Alpha is 1 – confidence level, usually 0.05. Click on the cell with standard deviation. Size refers to the sample size. Upper Limit of Confidence Interval: (mean + confidence interval). There is no command for this in Excel. Lower Limit of Confidence Interval: (mean – confidence interval). There is no command for this in Excel. Correlation Coefficient (R): =CORREL(click and drag on cells in array 1, click and drag on cells in array 2); click “enter”. Regression Sum of Squares (R2): Multiply Correlation Coefficient by itself. There is no command for this in Excel. z-values (Table): =NORM.S.INV(0.9750); click “enter”. You will use this to find the value at a 95% confidence, two-tailed test. Standard Deviation for Binomial Distribution: =SQRT((p)(p-1)/n); click “enter”. Charts, Plots, and Graphs Scatter Plots: 1. Highlight data (all variables). If your data is not next to each other, hold the “control” key while highlighting the other variables. 2. Click “Insert”. 3. Click on the scatter plot. Pareto Charts: Creating Pareto Charts on Excel involves several steps; refer to online tutorials for detailed step-by-step instructions. Circle Charts (Pie Charts): 1. Highlight data. If data is in different places, follow instructions listed for Pareto Charts. 2. Click “Insert”. 3. Click on Pie Chart. Bar Graphs: 1. Highlight data. If data is in different places, follow instructions listed for Pareto Charts. 2. Click “Insert”. 3. Click on Bar Chart. Histograms and Bar Graphs: Follow instructional videos for creating histograms and bar graphs, as steps are similar to other charts. Guide for Charts/Graphs: Use a small sample of data to generate frequency tables for all charts. For bar charts, create a frequency table by counting categorical data such as studios or genres using functions like COUNTIF. For time series plots, prepare a table listing years, highest box office for each year, and the studio generating it, then plot using scatter plots with markers and labels. Pie charts require counting instances of categories such as genres or ratings and creating frequency tables. For range-based charts like histograms, categorize data into specified intervals and count data points in each category. Proper labeling, titled axes, and clear legends are essential for all charts to ensure interpretability. This comprehensive approach ensures accurate representation and analysis of film data using Excel’s statistical tools and charting features.