Statistics and Excel 2 Questions

In: Science

Submitted By Homeworkdone
Words 510
Pages 3
1. Describe ways in which the use of MS Excel as a tool for interpreting data can be used by a manager of an organization.
Many tools of MS Excel are available to analyze statistical data beyond the basic statistical analysis. Such tools include regression analysis, simulations, control charts, summaries, and forecasting. Other important data that can be obtained using the expanded MS Excel financial functions is performance level calculations, principle payment calculation, depreciation of an asset, interest payment on investment, present value of investment, calculation of interest rate over time, annual duration of the security, current and future rates of investment, and amortization. The logical functions help calculation based on the requirements such as if, or, and, true and false. MS Excel also has an integration that allows to import information stored in COM applications. MS Excel also has a series of arithmetic and geometric functions. Additionally, MS Excel has a number of functions for engineering applications such as Bessel functions, binary and hexadecimal. Other functions include correlation, covariance, sum of squares, exponential means, permutations, quartiles, Student’s t-distribution, z test , and others.
The manager can effectively utilize these tools in interpretation of data sets and creating queries without using MS Access. The manager can effectively calculate all the needed statistics without having to go through extensive calculations. By using Data Analysis, the manager can calculate the statistical data and test the statistics for significance with a few pushes of the button.
MS Excel is integrated with MS Access and the data can be kept in both database and excel formats.
2. What potential legal and ethical issues could arise if the information gained in this survey was used to create an ideal profile of characteristics that the…...

Similar Documents

Statistic

...2-1 a. PV- Present Value, the beginning amount. Int- Interest per year FV- Future Value or ending amount in an account where N is the number of periods the money is left in the account. PVA- Present value annuity FVA- Future value annuity and the ending value of a stream of equal payments. PMT- Payment M- Number of compounding period per year I nom- The nominal , or quoted, interest rat b. Opportunity cost rate- is the rate of return you can earn on an alternative investment of a similar risk. c. Annuity- a series of equal periodic payments for a specific number of periods. Lump sum payment- When you pay a large amount of amount due. Cash flow- annuities with their equal payments in each period Uneven cash flow stream- happens when a series of payments of annuity payments plus final lump sum. d. Ordinary annuity- an annuity whose payments occur at the end of each period. Annuity due- If payments are paid in the beginning of each period, then we have an annuity due. e. Perpetuity- is an annuity with an infinite number of payments. Consul- it promises to pay interest perpetually, they are called perpetuities. Perpetuity is a simply an annuity with an extended life. f. Outflow- the outflow of the payment when completed. Inflow- the inflow of the present value Time line- helps visualize what’s happening in a...

Words: 518 - Pages: 3

Statistics and Excel 2 Questions

... Data Analysis, the manager can calculate the statistical data and test the statistics for significance with a few pushes of the button. MS Excel is integrated with MS Access and the data can be kept in both database and excel formats. 2. What potential legal and ethical issues could arise if the information gained in this survey was used to create an ideal profile of characteristics that the company looked for when hiring employees? It is impossible to create an ideal profile of characteristics of potential employees. Every organization requires a different set of skills and qualifications regarding the position, as well as every candidate is diversified in the skills, experiences, and talents that he or she brings to the organization. An organization employs many individuals of various backgrounds to create a diversified working environment. Organizations have different codes of ethics, mission statements, specializations. Leveling every potential employee to a set of basic criteria will hinder the companies from hiring individuals with special talents relevant to the job. It is improper and unlawful to discriminate individuals in regards to employment, and there are many laws that describe the intricacies and responsibilities associated with the hiring process. Most of the organizations in US are “Equal Opportunity Employers” and do not have the right to discriminate against social, cultural, and religious background, as well as gender, age, or ethnicity. Another......

Words: 510 - Pages: 3

Statistic

...Established in 1979, Gulf Properties was the first full service Real Estate office located directy on Navarre Beach. Our resort rentals range from small condominiums and efficencies to large beach houses. Our Realtors are specialist in condominium sales as well as residential land and homes and commercial properties in the Navarre Area. When you stay with Gulf Properties, you are supporting local business and independent property owners that keep our beaches beautiful and our community strong. The confidence interval (also called margin of error) is the plus-or-minus figure usually reported in newspaper or television opinion poll results. For example, if you use a confidence interval of 4 and 47% percent of your sample picks an answer you can be "sure" that if you had asked the question of the entire relevant population between 43% (47-4) and 51% (47+4) would have picked that answer. The confidence level tells you how sure you can be. It is expressed as a percentage and represents how often the true percentage of the population who would pick an answer lies within the confidence interval. The 95% confidence level means you can be 95% certain; the 99% confidence level means you can be 99% certain. Most researchers use the 95% confidence level. When you put the confidence level and the confidence interval together, you can say that you are 95% sure that the true percentage of the population is between 43% and 51%. The wider the confidence interval you are willing to...

Words: 580 - Pages: 3

Statistic

...ANSWER: 1 a) Year | Code | Net Sales ($) | 1997 | 1 | 50,600 | 1998 | 2 | 67,300 | 1999 | 3 | 80,800 | 2000 | 4 | 98,100 | 2001 | 5 | 124,400 | 2002 | 6 | 156,700 | 2003 | 7 | 201,400 | 2004 | 8 | 227,300 | 2005 | 9 | 256,300 | 2006 | 10 | 280,900 | 2007 | 11 |   | 2008 | 12 |   | 2009 | 13 |   | 2010 | 14 | 384668 | b) Graph: ANSWER: 2 a) Year | Code | log y | Imports of Carbon Block (thousands of tons)(y) | 1990 | 1 | 2.09342169 | 124 | 1991 | 2 | 2.24303805 | 175 | 1992 | 3 | 2.48572143 | 306 | 1993 | 4 | 2.71933129 | 524 | 1994 | 5 | 2.85369821 | 714 | 1995 | 6 | 3.02201574 | 1052 | 1996 | 7 | 3.2143139 | 1638 | 1997 | 8 | 3.39146441 | 2463 | 1998 | 9 | 3.52608069 | 3358 | 1999 | 10 | 3.62128017 | 4181 | 2000 | 11 | 3.73142759 | 5388 | 2001 | 12 | 3.90455326 | 8027 | 2002 | 13 | 4.02477291 | 10587 | 2003 | 14 | 4.13152243 | 13537 | 2004 | 15 |   | | 2005 | 16 |   | | 2006 | 17 |   | | Graph: b) Y= 0.157x+2.033 Here, Logb= 0.157 b= antilog (0.157) b= 1.435 Geometric Mean= b-1 = 0.43549 =0.43549*100 = 43.55% c) logy06= 0.157x+2.033 = 0.157(17)+2.033 = 4.702 y06= antilog (4.702) = 50350.06 thousand of tons ANSWER: 3 a) Year | Quarter | Production (in million) | Fourth-quarter total | Fourth-Quarter moving average | Centered moving average | Specific seasonal...

Words: 1091 - Pages: 5

Statistic

...Term Paper Guideline STAT 500 Length: Less than 1500 words Format: Cleanly typed Students are required to write an article describing a statistical method that will solve a business or management problem; or an creative approach that mainly rely on statistical methods that would advance the current practice. The statistical method involved may or may not relate to statistical concepts or methods covered in the course. Students are encouraged to conduct their own literature research. Information collected from books, magazines or newspapers are acceptable, including any of those found in UNVA’s eLibrary. Students could invent their own practical and feasible solutions to some real issues they experience in their work, though not required. The article should describe well the background of the problem and each of the steps in solving the problem. The length of the article should be within 1500 words; visual aids, such as tables, charts, graphs should be included where necessary. Some business statistics applications example include • Select profitable stocks • Detect fraudulent claims • Score an applicant’s credit • Discover cross-selling opportunities for products • Quantify drug efficacy • Forecast new product sales • Discover new customers • Recognize objects in images • Verify identity through biometrics; and • Anticipate shifts in market sectors for hedge funds • Set...

Words: 430 - Pages: 2

Statistic

... the AOV in Table 10-5, SSR =(0.75) $ (2.02) = 1.52 Ssr = (0.25) $ (2.02) = 0.51 In more complicated regression models, it is often desirable to adjust for the degrees of freedom of regression by R Radj 2 ( 2 Ra2dj ! 1" MSr /MSY For the liver-body weight examples (Table 10-4) Radj 2 ! 1" 0.13 / (2.02 / 5) ! 0.68 Note that the considerable reduction in R2 (from 0.75 to 0.68) is a result of the large adjustment due to the small number of regression points. In the case of corn data in Table 10-7, R2 = 24459.36/26302.81 = 0.93 and Radj = 1 - [141.8/(26302.81/14)] = 0.925 2 This is a relatively small change due to the greater number of degrees of freedom. 10.5 Confidence limits for the regression coefficient (') The mean square for residuals from regression (Msr) can be used as an estimate of the population variance if there is no significant lack of fit. Its square root is used to compute standard errors for various statistics associated with regression. The standard error of the regression coefficient b is Sb Sb ! [MSr / #(X " X)2 ]1/2 To construct a confidence interval for the true regression coefficient, we need a t-statistic which is defined as t = (b - '/Sb with df = k-2 where ' is the true regression coefficient. This formula provides a t-test for significance for a nonzero ' equivalent to the F-test of the AOV for regression. The confidence limits of ' for a given ) are, b + t,),k-2 •Sb The 95% C. L. for for the regression of liver weight on...

Words: 7686 - Pages: 31

Statistic

...If A and B are mutually exclusive events with P(A) = 0.70, then P(B) can be any value between 0 and 1. can be any value between 0 and 0.70. cannot be larger than 0.30. None of the above statements are true. If A and B are independent events with P(A) = 0.20 and P(B) = 0.60, then P(A|B) is 0.2000 In the notation below, X is the random variable, c is a constant, and V refers to the variance. Which of the following laws of variance is not correct? V(c) = 0 V(X + c) = V(X) V(X + c) = V(X) + c V(cX) = c2 V(X) Which of the following statements is always correct? P(A and B) = P(A) * P(B) P(A or B) = P(A) + P(B) P(A or B) = P(A) + P(B) + P(A and B) P[pic]= 1- P(A) An experiment consists of tossing an unbiased coin three times. Drawing a probability tree for this experiment will show that the number of simple events in this experiment is 8 Use the following information to answer questions 6 and 7: The weights of newborn children in the United States vary according to a normal distribution with mean 7.5 pounds and standard deviation 1.25 pounds. The government classifies a newborn as having low birth weight if the weight is less than 5.5 pounds. What proportion of babies weigh less than 5.5 pounds at birth? 0.0548 If the government wanted to change the value 5.5 pounds to a weight where only 2% of newborns weigh less than the new value, what weight should they use? 4.9375 pounds If you are given a table of joint probabilities of two events...

Words: 549 - Pages: 3

Question 2

...Question 2: Accounting for Goodwill has been a contentious issue for many years. a. Using examples, explain alternative accounting methods that can be used in practice with respect to the treatment of goodwill arising on consolidation. b. Discuss the advantages and disadvantages of allowing different treatments to be used under international accounting standards for items such as goodwill. Answer. Goodwill means an intangible asset which provides a competitive advantage, such as a strong brand, reputation, or high employee morale. In an acquisition, goodwill appears on the balance sheet of the acquirer in the amount by which the purchase price exceeds the net tangible assets of the acquired company (www.investorwords.com). There are two types of goodwill, one is internally generated goodwill and another one is external or purchased goodwill. Internally generated goodwill is supposed to reflect the reputation and other positive characteristics of the business which are all difficult to put a value on (www.staffs.ac.uk). Internally generated goodwill is based on the value of a business as a whole and the value of its net assets. Because of internal goodwill has not been paid and it does not have an ‘objective’ value, and goodwill changes every day, internally generated goodwill should not appear on the Balance Sheet. Purchased goodwill is the excess of purchase price over fair value of the net assets of the business acquired by the purchaser. Purchased...

Words: 790 - Pages: 4

Statistic

...* 25 Mod 2. Examine how accruals affect the current liability category. 1* 30 Mod 6* 25 Mod 3. Demonstrate an understanding of how changes in current 2 20 Mod liabilities affect the statement of cash flows. 3 20 Mod 4* 25 Mod 4. Determine when contingent liabilities should be presented on the 4* 25 Mod balance sheet or disclosed in notes and how to calculate their amounts. 5 20 Mod 8 30 Mod 9 20 Mod 5. Explain the difference between simple and compound interest. 6. Calculate amount using future value and present value concepts. 7. Apply the compound interest concepts to some common 7 25 Mod accounting situations. 8. Demonstrate an understanding of the deductions and expenses for payroll accounting. (Appendix 9A) 9. Determine when compensated absences must be accrued as a liability. (Appendix 9A) *Exercise, problem, or case covers two or more learning objectives Level = Difficulty levels: Easy; Moderate (Mod); Difficult (Diff) QUESTIONS 1. A current liability is an obligation that will be satisfied within the next operating cycle, or within one year if the cycle is shorter than one year. Current liabilities are important to determine a firm's liquidity, i.e., its ability to pay for those items due within a short time period. 2. Generally, it is to the company's benefit to take advantage of discounts available because of the rate of the discount. For example if a 2...

Words: 11002 - Pages: 45

Statistic

...STATEMENT OF PROBLEM: The study aims to understand the different cause of computer games addiction and manage their time on study and playing games. Specifically this study seeks to answer this following questions: 1. What are the cause of computer games addiction as perceived by the students? 2. What are the advantages and disadvantages of being addicted to computer games? 3. What are the proposed ways to eradicate computer games addiction? PANPACIFIC UNIVERSITY NORTH PHILIPPINES Lopez Jaena St. Tayug, Pangasinan Name: (Optional) ____________________ Gender: ________ Age : ___ Course: _________ Computer Addiction This study attempts to determine the problems encountered by the students of PUNP that affect their performance in addiction of computers. I. Study the effects and cause the students in computer games addiction. Direction: Put checkmark on the space provided that affect and cause in computer games addiction Problem 1. I prefer playing games to spend time with my friends 2. I find satisfaction in playing games 3. I think playing computer games is the answer to my problem 4. I prefer playing sports game in computer rather than playing it in real-life situation 5. I build interconnection with other computer gamers 6. I want online games to gain respect to other students 7. I prefer playing online games for pastime 8. I feel frustrated if I did...

Words: 587 - Pages: 3

Statistic

...1.22 a.all U.S cats b 1. categorical 2. categorical 3. numerical,it is discrete 4. categorical c 1.where cat food is primarily purchased? 2.whether dry or moist cat food is purchased? 3.whether the cat is pedigreed 4.which cat food brand you uasually purchase? 5.would you want to try another new brand? d 1.the number of cats living in the household? 2.how often do you purchase cat food in one month? 3.how many kilograms of cat food you usually purchase once? 4.how old is you cat? 5.how often you feed your cat in one day? 1.24 a 1.4.6.9. b 2 .3.5.7.8.10.11.12.13.14 c.2.10.13 2.78 a. [pic] b the amount of soft drink decline continuously c less than 1.894 d because we focus on the tendancy of the amount of soft drink,and the time series plot is more straight and clear than a histogram. 2.84 a |Class |midpoint |frequency |Percentage | |[0.15,0.45) |0.3 |34 |3.92 | |[0.45,0.75) |0.6 |42 |4.84 | |[0.75,1.05) |0.9 |203 |23.39...

Words: 1023 - Pages: 5

Statistic 2 Midterm Exam

...Question 1 (22 marks) A commercial pool management company is seeking to reduce the costs of maintaining swimming pools. The maintenance cost is mostly driven by the amount of chlorine that is needed to keep the water clear and relatively free of germs. The company hired a new graduate from York University (“YorkU”) to analyze how much chlorine is needed. It is believed that the speed at which chlorine is depleted is dependent on the temperature (degrees Fahrenheit) of the water (higher temperatures use chlorine faster); pH level, which is a measure of the acidity of the water (pH ranges from 0 to 14, where 0 is very acidic and 14 is very alkaline; levels around 7.5 use the least chlorine); and weather (sunshine uses up chlorine). The YorkU graduate recorded the percentage of chlorine depletion during 8-hour days, water temperature, pH level and weather condition (mainly cloudy, sunny and partly sunny). Using Excel’s Regression Tool, the YorkU graduate obtained the following Excel output. Regression Statistics Multiple R A R Square B Adjusted R Square C Standard Error D Observations 210 ANOVA df SS MS F Significance F Regression E 6596 I 77.00 0.0000 Residual F H J Total G 10091 Coefficients Standard Error Intercept 1003 55.12 18.19 0.0000 Temperature 0.194 0.029 K 0.0000 PH Level -265.6 14.75 -18.01 0.0000 PH Level-Sq...

Words: 723 - Pages: 3

Excel

... has FP rate of 0 and TP rate of 0, represented as point (0, 0). The “classification” that assigns “Test Positive” to every value has FP rate of 1 and TP rate of 1, represented as the point (1, 1). Joining all known (x, y) points by straight lines, the area under the resulting empirical ROC curve is known as the Area Under the Curve or AUC. The AUC ranges from 0.5, for a test no better than chance, to 1, for a perfect test. The Area Under the Curve is calculated by the summation of the average height multiplied by the width, as follows: ! ! T P (n) + T P (n + 1) 1 2 (F P (n + 1) F P (n)) See Excel Spreadsheets for examples of calculating each point on an empirical ROC Curve. 2 2.1 2.1.1 Information Measures Probability Review Basic Probability Definitions Joint probability: p(X, Y ) The probability that both X and Y are true. Joint probability is commutative: p(X, Y ) = p(Y, X). Conditional probability: p(X|Y ) The probability that X is true, given that Y is true. Note that “Rates,” PPV and NPV are Conditional Probabilities: True Positive Rate = p(T P T est|+), 3 False Negative Rate = p(F N T est|+), False Positive Rate = p(F P T est| ), True Negative Rate = p(T N T est| ), Positive Predictive Value = p(+|T est P ositive), Negative Predictive Value = p( |T est N egative). Marginal probability: p(X) The probability that X is true, independent of the value of Y. Product distribution: p(X)p(Y ) The product of two marginal...

Words: 4475 - Pages: 18

Statistic

...1. The researchers analyzed the data they collected as though it were at what level of measurement? Ordinal 2. What was the mean posttest empowerment score for the control group? 97.12 3. Compare the mean baseline and posttest depression scores of the experimental group. Was this an expected finding? Provide a rationale for your answer. The baseline 14.00 and posttest 13.36. Yes. It shows that there were little to no change in depression. 4. Compare the mean baseline and posttest depression score of the control groups? Provide a rationale for your answer. Both the baseline and posttest depression score were 10.40. This score indicates that the self management of ESRD may benefit from Empowerment Intervention in the future. 5. Which group’s score had the least variability or dispersion? Provide a rationale for your answer. The control group had the least amount to variability of dispersion. The control group only had one are of dispersion that was self-care/ self efficacy for the baseline and posttest. 6. Did the empowerment variable or self-care self efficacy variable demonstrate the greatest amount of dispersion? Provide a rationale for your answer. Self-care self efficacy SD baseline 14.02 posttest 12.24: empowerment SD baseline 9.02 posttest 8.91 7. The mean is a measurement of central tendency of a distribution while the SD is measure of dispersion of its scores. Both X and SD are descriptive statistics. 8. What was the mean...

Words: 448 - Pages: 2

Statistic - Week 2 Practice Worksheet

...University of Phoenix Material Week 2 Practice Worksheet Prepare a written response to the following questions. Chapter 3 1. For the following scores, find the mean, median, and the mode. Which would be the most appropriate measure for this data set? 2, 2, 0, 5,1, 4,1, 3, 0, 0, 1, 4, 4, 0,1, 4, 3, 4, 2, 1 2. Based on the scale of measurement for each variable listed below, which measure of central tendency is most appropriate for describing the data? a. The time (in years) it takes a sample of students to graduate college b. The blood type (e.g., Type A, B, AB, O) of a group of participants c. The rankings of college undergraduate academic programs Chapter 4 3. An expert reviews a sample of 10 scientific articles (n = 10) and records the following numbers of error in each article: 0, 4, 2, 8, 2, 3, 1, 0, 5, and 7. Compute the SS, the variance, and the standard deviation for this sample using the definitional and computational formulas. 4. A psychologist interested in political behavior measured the square footage of the desks in the official office for four U.S. governors and of four chief executive officers (CEOs) of major U.S. corporations. The figures for the governors were 44, 36, 52, and 40 square feet. The figures for the CEOs were 32, 60, 48, 36 square feet. a. Figure the means and standard deviations for the governors and CEOs. b. Explain, to a person who has never had a course in statistics, what you have done. c...

Words: 927 - Pages: 4