...behavior of 50 couples who are selected from a sample size of 194 couples. 1. Descriptive statistics 2.Histograms 3.Pivot tables 4.Multiple Regression In this model , a scrutiny of the above statistical data will give the tendency to invest in retirement plans and the type of couples who invest and take advantage of the attractive investments in order to avail tax exemption. This report also elaborates on how the different independent variables - Number of children, Salary, Mortgage and Debt- have an effect on the dependent variable, i.e. the percentage of salary invested. Consequently the below tasks will be fulfilled. Step 1-Extracting a sample of 50 couples Step 2-Constructing histograms and point estimates with given confidence intervals Step 3-Inference from pivot tables to explain the preferences of different couples on investments based on independent variables Step 4-Performing multivariate regression and conducting significance tests on beta coefficients R^2 and F-tests and hence establish a correlation of different variables and ensuing effect on investments made. Dataset We have a sample of 194 couples whose financial data along with number of children belonging to each couple have been listed. The financial data includes the following: 1. combined annual salary of husband and wife 2.current mortgage on home 3.average amount of other debt 4.percentage of income invested in retirement plans Step1- Sample extraction In this step, in order to carry...
Words: 1895 - Pages: 8
...QTM 3650 – Prof. Rick Cleary Class #9–Mon. 2/24/14 I.) Logistics - Return and discuss homework problems 12-14; notes below. Collect problems 15-16. - Final exam time for our class: Wednesday 5/7, 3:30 – 5:30 PM, Gerber 103. - Review schedule for upcoming two weeks: 10Weds. 2/26 | Classification and Regression TreesProject 1 dueTake home part of Exam #1 assigned | Text Chapter 9 | 11Mon. 3/3 | Finish Chapter 9Catch up/review/special topics/Visualization tools | - | 12Weds. 3/5 | EXAM #1In class portion and take home due | - | - A note on ground rules for the in-class exam: Each student may bring one 8.5” by 11” review sheet to the exam with them; OK to write on both sides. The sheet will be turned in with the exam. No electronic devices of any kind except for a calculator that can do simple arithmetic. It’s OK to use a hand-held device (not a laptop) as a calculator as long as it is used only for that purpose. If students don’t have a calculator, Prof. Cleary will have a couple on hand, or students may use the podium computer to do calculations only in Excel. Any connection to the internet or communication to others (texting, etc.) during the exam will be considered an academic integrity violation. - Today’s topics: Finish Chapter 8 on the naïve Bayes estimator and review the Chi-Squared test of independence. II.) Comments on homework problems 12-14. Problem 12.) While we reviewed this last...
Words: 2010 - Pages: 9
...Project Title: Employee retention at D&Y consulting firm Section E: Group 2:Anshul Garg (11FN-015)-Finance Gokul Sudhakaran(11DM-039)-Marketing Kaviya .A. (11DM-057)- Marketing Nikhil Gagrani(11DM-089)- Marketing Sheth Dharmil Nirupam(11DM-147)-Marketing Taru(11IB-061)-International Business Submission Date:- 9th September,2011 TABLE OF CONTENTS 1. Case 2. Objective of the problem 3. Methodology used 4. Analysis 5. Excel output 6. Conclusion 7. Managerial implications CASE: EMPLOYEE RETENTION AT D&Y CONSULTING FIRM Demand for systems analysts in the consulting industry is very strong. Graduates with experience in the consulting business and those who have extensive computer knowledge are getting great offers from consulting companies. Once these people are hired, they frequently switch from one company to another as competing companies lure them away with even better offers. One consulting company, D&Y, has collected data on a sample of system analysts they hired with an undergraduate degree several years ago. Following are the variables in the attached excel file: StartSal: Employee's starting salary at D&Y. OnRoadPct: Percentage of time employee has spent on the road with clients. StateU: Whether the employees graduated from the State University. CISDegree: Whether the employee majored in computer Information Systems or a similar program...
Words: 1889 - Pages: 8
...About a population based on sample data Population: all items of interest Sample: a subset of a population Population: all items of interest Measures of reliability: built into statistical processes (p5) two kinds: confidence level & significance level 1. confidence level proportion of times an estimation procedure will be correct90%-99% 2. Significance level: how frequently a conclusion will be incorrect, in the long run. 1%-10% Types of Data and Information hierarchy of data traingel base nominal: lable, catagoty numerical values represent categories…”coding data” how to count =countif(A1:A11)1 (数1 有多少个) =AVERAGE(a2:a11) counting the frequency of the numbers used as codes top :interval middle ordinal data: order distances are not equal, eg. records in marathon values must represent the ranked order of data interval data: all calculations are permissible random variable: numerical alue random outcome determined by chance upon conducting an experiment numerical data:v qualitative (categorical) quantitative (numerical) qualitative data 1. nominal labels, coding, assigned values 2. ordinal order important quantitative data 1. interval differences are meaningfull/usually equal distances 2. ratio differences are meaningfull zero starting point EX p17 2.3 a. interval b. nominal c. ordinal d.interval e.interval 2.4 a.interval b.interval c.nominal d.interval e nominal CHAPTER 2 Pivot table chapter 2 eg.10 p32 Xm...
Words: 627 - Pages: 3
...Homework #2 – Excel Charts and Pivot Tables Overview and Learning Objectives This homework assignment asks you to use Microsoft Excel to use the VLookup function in a report, and also to generate charts and pivot tables. These are all useful skills. VLookup simplifies spreadsheet logic in many situations, and charts offer a visual perspective that can help people to see trends and data relationships. And once you get the idea of pivot tables, they are extremely useful in summarizing data “on the fly” in a variety of formats. This assignment is related to course objective #4 (“Design and implement Microsoft Excel spreadsheets and Microsoft Access databases to support business decision making”). Quality Furniture Enterprises, Continued This homework assignment continues the scenario from Homework #1, about Quality Furniture Enterprises. Caitlin’s uncle (and boss) was pleased with the sales forecast report she created. “I guess I should learn Excel,” he says. “I’ve been using the calculator on my laptop to compute the totals, and then copying and pasting things into a Word document.” Caitlin did her best not to appear smug, but it was nice to be appreciated, especially since this was still her first month on the job. But before she had any time to bask in her success, her uncle said, “And since you did so well on that report, I have another project for you.” So much for taking an early lunch break today. “Sure,” she said. “What do you need?” “First off, remember how I told...
Words: 1904 - Pages: 8
...Learning organization For more information about SPSS Inc. software products, please visit our Web site at http://www.spss.com or contact SPSS Inc. 233 South Wacker Drive, 11th Floor Chicago, IL 60606-6412 Tel: (312) 651-3000 Fax: (312) 651-3668 SPSS is a registered trademark and the other product names are the trademarks of SPSS Inc. for its proprietary computer software. No material describing such software may be produced or distributed without the written permission of the owners of the trademark and license rights in the software and the copyrights in the published materials. The SOFTWARE and documentation are provided with RESTRICTED RIGHTS. Use, duplication, or disclosure by the Government is subject to restrictions as set forth in subdivision (c) (1) (ii) of The Rights in Technical Data and Computer Software clause at 52.227-7013. Contractor/manufacturer is SPSS Inc., 233 South Wacker Drive, 11th Floor, Chicago, IL 60606-6412. Patent No. 7,023,453 General notice: Other product names mentioned herein are used for identification purposes only and may be trademarks of their respective companies. Windows is a registered trademark of Microsoft Corporation. Apple, Mac, and the Mac logo are trademarks of Apple Computer, Inc., registered in the U.S. and other countries. This product uses WinWrap Basic, Copyright 1993-2007, Polar Engineering and Consulting, http://www.winwrap.com. Printed in the United States of America. No part of this publication may be reproduced, stored...
Words: 24142 - Pages: 97
...| Course Design Guide School of Business ACC/542 Version 3 Accounting Information Systems | Copyright © 2012, 2009, 2007 by University of Phoenix. All rights reserved. Course Description In this course, students examine the fundamentals of accounting systems design. Topics include business information systems, business processes and data flows, database concepts and tools, internal control and risks, auditing the information system, and using the information system to perform audit functions. Policies Faculty and students/learners will be held responsible for understanding and adhering to all policies contained within the following two documents: University policies: You must be logged into the student website to view this document. Instructor policies: This document is posted in the Course Materials forum. University policies are subject to change. Be sure to read the policies at the beginning of each class. Policies may be slightly different depending on the modality in which you attend class. If you have recently changed modalities, read the policies governing your current class modality. Course Materials Bagranoff, N. A., Simkin, M. G., & Strand Norman, C. (2008). Core concepts of accounting information systems (10th ed.). New York, NY: Wiley. Hunton, J. E., Bryant, S. M., & Bagranoff, N. A. (2004). Core concepts of information technology auditing. Hoboken, NJ: Wiley. O’Brien, J. A. & Marakas, G. M. (2008). Management information...
Words: 2104 - Pages: 9
...• System Integrity/Validation and Final Project Summary o Project Summary o Over the past six weeks, our firm has analyzed the accounting information systems of Kudler Fine Foods. We have discussed their current computer system and evaluated the possibility of threats to it and recommend integrated software solutions. The T3 line at Kudler is clearly more data transmission than is necessary for the company, so it was recommended they switch to T1 dedicated line to reduce costs. Due to the importance of inventory control, we showed management how to take their current inventory data tables and construct pivot tables to improve decision making on inventory. Internal controls were reviewed on payroll, accounts payable, accounts receivable, and inventory processes to ensure the accuracy and validity of data. The review determined that if Kudler does not implement the recommended internal controls system suggested, the business could be under serious threats. Information Technology (IT) auditing is another important improvement that Kudlers should make since our analysis showed that there are risks and vulnerabilities in the AIS process. Our final recommendation will be in the way that the audit process is improved by using computer assisted auditing techniques. This will complete the firm’s analysis and recommendations for Kudler Fine Foods. o Our firm last week analyzed and recommended different types of Information Technology (IT) audits that Kudler Fine...
Words: 1144 - Pages: 5
...LINEAR PROGRAMING AND SIMPLEX METHOD Devharajan Rangarajan Department of Electronic Engineering National University of Ireland, Maynooth devharajan.rangarajan.2016@mumail.ie Abstract— An optimization problem consists of maximizing or minimizing a real function by systematically choosing input values from within an allowed set and computing the value of the function. This pays way to a new world of constrained optimization. This paper focuses on one such optimization technique known as Linear programming and one of its method known as Simplex method in detail with examples. cTx = c1x1 + · · · + cnxn The subject of linear programming can be defined quite concisely. It is concerned with the problem of maximizing or minimizing a linear function whose variables are required to satisfy a system of linear constraints, a constraint being a linear equation or inequality. The subject might more appropriately be called linear optimization. Problems of this sort come up in a natural and quite elementary way in many contexts but especially in problems of economic planning. (or Ax ≤ b) I. INTRODUCTION Linear programming is the process of taking various linear inequalities relating to some situation, and finding the "best" value obtainable under those conditions. A typical example would be taking the limitations of materials and labour, and then determining the "best" production levels for maximal profits under those conditions. In "real life", linear...
Words: 1927 - Pages: 8
...|[pic] |Course Syllabus | | |School of Business | | |ACC/542 Version 2 | | |Accounting Information Systems | Copyright © 2009, 2007 by University of Phoenix. All rights reserved. Course Description In this course, students examine the fundamentals of accounting systems design. Topics include business information systems, business processes and data flows, database concepts and tools, internal control and risks, auditing the information system, and using the information system to perform audit functions. Policies Faculty and students/learners will be held responsible for understanding and adhering to all policies contained within the following two documents: • University policies: You must be logged into the student website to view this document. • Instructor policies: This document is posted in the Course Materials forum. University policies are subject to change. Be sure to read the policies at the beginning of each class. Policies may be slightly different depending...
Words: 2534 - Pages: 11
...1.0 INTRODUCTION 1. Background of the Study: The research investigates the impacts of social networking websites on undergraduate students’ performance at Technology College Sarawak. The variables identified are age, gender, education, social influence and academic performance. Questionnaire will be design based on the requirement to determine the reasons and factors that affect the students’ performance and will be distributed to 30 correspondents, which consist of students in Technology College Sarawak. Social networking is the grouping of individuals into specific groups, like small rural communities or a neighborhood subdivision, if one’s will. Although social networking is possible in person, especially in the workplace, universities, and high schools, it is most popular online. An online social networking is a place where people build social relations by sharing information’s, interests, activities, or their real lives connections too. It allows users to communicate with each other without limits and boundaries. When it comes to online social networking, websites are commonly used. These websites are known as social sites. Social networking websites function like an online community of internet users. Depending on the website in question, many of these online community members share common interests in hobbies, religion, politics and alternative lifestyles. Once the user is granted access to a social networking website they can begin to socialize...
Words: 6596 - Pages: 27
...data series homogenous? b) Summarize the data in an appropriate number of classes. Construct the frequency distribution. c) Calculate and interpret for the frequency distribution the average, standard deviation and coefficient of variance. Compare with the results from point a). Explain the differences. d) Construct a histogram and describe the shape of the distribution based on the histogram. e) In which interval is expected that about 95% of the data will fall? Is this assumption true for this data? II. Using the “Pivot Table Wizard” in EXCEL, build a pivot table on your spreadsheet (using also the second variable). You may have to change the order of the rows (You should define the intervals first using VLookup function. III. Calculate the regression line and interpret and test the regression coefficients, coefficient of determination and coefficient of correlation. Interpret the results. Introduction: We chose for analysis a sample of 41 countries, considering the relationship between the following two variables: the Human Development Index(HDI) and the Gross Product per Capita (GDP)[1]. The values...
Words: 1590 - Pages: 7
...Impact Of a Water Jet • Introduction: Over the years, engineers have found many ways to utilize the force that can be imparted by a jet of fluid on a surface diverting the flow. For example, the pelt on wheel has been used to make flour. Further more, the impulse turbine is still used in the first and sometimes in the second stages of steam turbine. Firemen make use of the kinetic energy stored in a jet to deliver water above the level in the nozzle to extinguish fires in high-rise buildings. Fluid jets are also used in industry for cutting metals and debarring. Many other applications of fluid jets can be cited which reveals their technological importance. This experiment aims at assessing the different forces exerted by the same water jet on a variety of geometrical different plates. The results obtained experimentally are to be compared with the ones inferred from theory through utilizing the applicable versions of the Bernoulli and momentum equations. • Objectives: 1. To determine the force produced by a water jet when it strikes a flat vane and a hemispherical cup. 2. To compare the results measured with the theoretical values calculated from the momentum flux in the jet. • Theory: For the general case shown in figure (1) the momentum flux in the jet is (muo) Where: m is the mass flow rate Uo is the jet velocity just upstream of the vane. After being deflected through...
Words: 2110 - Pages: 9
...Excel 2010 Microsoft ® ® ® Formulas John Walkenbach BONUS CD-ROM! Includes all Excel workbook files used in the book, plus the complete book in a searchable PDF file Excel® 2010 Formulas by John Walkenbach Excel® 2010 Formulas Published by Wiley Publishing, Inc. 111 River Street Hoboken, NJ 07030-5774 www.wiley.com Copyright © 2010 by Wiley Publishing, Inc., Indianapolis, Indiana Published by Wiley Publishing, Inc., Indianapolis, Indiana Published simultaneously in Canada No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 7486011, fax (201) 748-6008, or online at http://www.wiley.com/go/permissions. Trademarks: Wiley, the Wiley Publishing logo, For Dummies, the Dummies Man logo, A Reference for the Rest of Us!, The Dummies Way, Dummies Daily, The Fun and Easy Way, Dummies.com, Making Everything Easier, and related trade dress are trademarks...
Words: 49651 - Pages: 199
...Business Analytics- * Exploring data to find new patterns and relationships (data mining) * Explaining why a certain result occurred (statistical analysis, quantitative analysis) * Experimenting to test previous decisions (A/B testing, multivariate testing) * Forecasting future results (predictive modeling, predictive analytics) Answers the Important Questions Such As: -Why did it happen? Will it happen again? What will happen if we change x? What else does the data tell us that never thought to ask? By Using: Statistical/Quantitative Analysis Data Mining Predictive Modeling Multivariate Testing Microsoft Excell- Microsoft Excel is a spreadsheet application . It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, SAS- SAS is a software suite developed by SAS Institute for advanced analytics, business intelligence, data management, and predictive analytics. It is the largest market-share holder for advanced analytics. SAS is a software suite that can mine, alter, manage and retrieve data from a variety of sources and perform statistical analysis on it. It is widely used in insurance, public health, scientific research, finance, human resources, IT, utilities, and retail, and is used for operations research, project management, quality improvement, forecasting and decision-making. JMP Pro- JMP is used...
Words: 495 - Pages: 2