BA 6933 Final Paper Submitted by Akhila Guntamukkala ID Number: 1418452 Statistics and Quantitative Methods October 14th, 2017. Statistical Methods is defined as methods of collecting, summarizing, analyzing, and interpreting variable numerical data. Statistical methods can be contrasted with deterministic methods, which are appropriate where observations are exactly reproducible or are assumed to be so. Quantitative methods emphasize objective measurements and the statistical, mathematical, or numerical analysis of data collected through polls, questionnaires, and surveys, or by manipulating pre-existing statistical data using computational techniques. To implement the statistical analysis that I have learned in this statistic …show more content…
Steps to construct the scatterplot given data by using excel. Excel (PHStat in Add-Ins) procedure: Step 1: Choose PH stat > Regression> Simple Linear Regression Step 2: In Y Variable Cell Range, enter the column containing the Y variable. Step 3: In X Variable Cell Range, enter the column containing the X variable. Step 4: In regression Tool Output Options, select the appropriate options. Step 5: In output Options, Select the scatterplot. Step 6: Click OK. EXCEL (PHStat in Add-Ins) Output: Obtain the slope (b1) and y- intercept (b0) of the linear regression equation for the given data by using Excel. Procedure to translate the management problem into a hypothesis assumption Excel (PHStat in Add-Ins) procedure: Step 1: Choose PH Stat> Regression> Simple Linear Regression. Step 2: In Y Variable Cell Range, enter the column containing the Y variable Step 3: In Y Variable Cell Range, enter the column containing the Y variable Step 4: In regression Tool Output Options, select the appropriate Options. Step 5: In output options, select the regression statistics, ANOVA and coefficient table. Step 6: Click ok. Excel (PHStat in Add-Ins) Outputs: Regression Statistics Multiple R …show more content…
Fun, innovative approach to evaluation causes to view through a unique perspective. W: Takes courage for people who are not accustomed to public display. May not speak to stakeholders while data collection. [S: = Strength and W: Weakness]. Findings and identify their implications for the organization or other stakeholders. The study was conducted using the sale data of a bookstore when compared with the number of the salesperson. We can clearly state that as the number of salesman increase the sales were increased this can be clearly proved using the scattered diagram. The methods that are used in finding is the regression statistics, Anona, and residual points. This is the best method to draw conclusions about the hypothesis and the sales in this business-related management problem. Upon seeing the residual point we can conclude that as the number of salesman increase the sales are getting down comparatively. This can be a threat for the stakeholders as that can put the business at risk and loss. Which means limited salesman get more profits to the