FROM MS EXCEL UNIT EXAM 2

• To deselect cell, select another cell to remove the selection from the previously active cell.
• To Use the Fill Handle, continue a series. The handle will automatically increment or decrement the value in the following cells.
• To Use AutoFit column width, double-click column line heading to make the cells adjust more space in that column.
• To Use Center Across Selection, perform from Alternative to merging.
• To Freeze Panes in a worksheet, you have to access by Showing Header Rows while Scrolling.
• To Sort data, follow the instructions: Data > A-Z or Z-A. This will automatically create the sorting-out process you need.
• To Remove all data-filtering, you have to click Filter again.
• To Use Charts in Excel, use Data Visualizations to discover all the materials you needed.
• To Open Same File in a different window, follow: View > New Window. This can also help you prevent from making mistakes during performance.
• To Create a Formula in Excel, use an Equal Sign with Math Equators. You can see the shown operators when you perform the instruction, a REMINDER to be careful on following proper function of indicating a formula based from what worksheet you are creating on.
• To Use Point-&-Click Method, make a quick and easy cell referencing. In doing this without much energy or manual work, this will help you accomplish it faster and less-error prone from inserting a cell.
• To Insert a Function, you have to follow proper syntax.
• Central Tendencies - describe where most of the values in the dataset occur.
• Dispersion indicates how closely clustered or loosely spread the data points fall around the center.
• Minimum and Maximum helps you identify outliers.
• Kurtosis indicates how the peaks and tails of your distribution compare to the normal.
• Skewness indicates the symmetry of your data distribution.
• Chi-squared test is used to determine whether the sample size is what you expected.
• Correlation Coefficient evaluates the relationship between a pair of variables through its sign and value..
• P-Value is compared to a value of significance level used in hypotheses test in analysis of variance or ANOVA.
• R-Squared indicates the percentage that the model will account for about its dependent variable's variance.
• Adjusted R-Squared helps us compare regression models with differing numbers of independent variables favoring the model.
• Standard Error indicates the typical size of residuals showing how wrong the regression model is on average.
• Significance F is the P-Value for the F-Test of overall significance determining whether your model is a good fit.
• Regression Coefficients serve as the proportionality value of the independent variable to the dependent in the regression model.
• Confidence Interval indicates the range of values that the actual population parameter is likely to fall at the certain confidence level.