Module code: BSS002-6
Module Name: Business Data Analysis

Submission: 30 November, 2012

I my class I learn how to simulate data to solve a problem. I learn to use excel and some function in it these are
=SUM()
= RAND()
=AVERAGE()
=STDV()
=RANDINV()
=VLOOKUP() and few more . These are widely used function when I simulated data in excel. In task 1 I find out how to calculate or forecast how much card should we print. I use a random variable with =RAND( function and use =VLOOKUP() function to find out demand from discreet variable called cumulative probabilities. This is discrete because we find out the range by frequency distribution. Then I use if function to calculate disposable cost with =IF (Demand>Production,(Demand-Production)*Disposable cost, 0). This function works with logical criteria. It says that, if demand is greater than production then disposable cost will be (Demand-Production)*Disposable cost, if not then “0”. Then I calculated profit. Then I simulated 1000 trial with 4 types demand to find out with demand will give us maximum profit and this was $40000. If we print $40000 cards then we can make profit of $57758 which is higher than other. Then we use DATA ANALYSIS add-in to simulate descriptive statistic. From here we can answer question no 2 also. If you print 20000 cards then will make profit of 46178 which is less than what can we make in 40000 printed cards. In here simulated demand is uncertain variable when is used for forecasting.

For task 2 we make a profit model, It is given in below,
Profit Model= (Selling Price –Direct Labor-Part Cost)xDemand-Fixed Cost And I calculated profit with this model. I critically analysis base case, worst case an best is. Worst case is, when cost is higher but demand is very low. In base case everything lies in middle and the best case cost is very low but price is very high. So in the 3 type of case best case gave us best profit. So I calculate some data with each...

...Midterm I
Econ 3790: Statistics for Business and Economics
Instructor: Yogesh Uppal
You are allowed to use a standard size (8.5*11) cheat sheet and a simple calculator. Please write all the answers with a
BALL-POINT PEN or an INK PEN. If you have any questions during the exam, please raise your hand. GOOD LUCK!!! I
am sure you guys will do great.
Multiple Choice
Identify the letter of the choice that best completes the statement or answers the question and write it in the space given
next to the question number. Each multiple choice question is worth 1 point.
____
____
____
____
____
1. In a questionnaire, respondents are asked to mark their gender as male or female. Gender is an example of the
a. ordinal scale
b. nominal scale
c. ratio scale
d. interval scale
2. Data obtained from a nominal scale
a. must be alphabetic
b. can be either numeric or nonnumeric
c. must be numeric
d. must rank order the data
3. In a post office, the mailboxes are numbered from 1 to 4,500. These numbers represent
a. qualitative data
b. quantitative data
c. either qualitative or quantitative data
d. since the numbers are sequential, the data is quantitative
4. A tabular summary of a set of data showing the fraction of the total number of items in several classes is a
a. frequency distribution
b. relative frequency distribution
c. frequency
d....

...STA 600
ASSIGNMENT 2
CHAPTER 3: DIAGNOSTICS AND REMEDIAL MEASURES
Diagnostic For Predicted Variable
Probems can occur when:
* Outliers exist among X levels
* X levels are associated with run order when experiment is run sequentially
Useful plots of X levels:
* Dot plot for discrete data
* Histogram /stem-and-leaf plot
* Box plot
* Sequence plot (versus time order)
Departures From Model To Be Studied By Residual
1. The regression function is not linear.
2. The error terms do not have constant variance.
3. The error terms are not independent.
4. The model fits all but one or few outliers,
5. The error terms are not normally distributed.
6. One or several important predictor(s) have been omitted from the model.
Diagnostic For Residuals
Six diagnostic plots to judge departure from the simple linear regression model
* Plot of residuals against predictor variable. (The plot should have a random scatter of plots)
* Plot of absolute or squared residuals against X.
* Plot of residuals against the fitted values.
* Plot of residuals against time or other sequence. (Should not display any trends)
* Plots of residuals against omitted predictor variables.
* Box plot of residuals.
* Normal probability plot of residuals. (Should lie along a straight line)
EXAMPLE
Predictor
Good Looking Plots
Figure: Normal probability plot...

...Gyroscope and
Accelerometer Data.
Introduction
Recently gyroscopes and accelerometers have become common components in smartphones.
Applications of these sensors include aligning the screen depending on how the phone is held and image
i
stabilization during photography. The goal of this analysis was determine whether data from these
sensors can be used to determine the activity that a smartphone user is engaged in. Only six basic
activities are considered: laying, sitting, standing, walking, stair climbing, and descending stairs. This
analysis suggests that data from these sensors can be used to differentiate between these activities with
a misclassification error rate less than 8%.
Methods
Data Collection
ii
The data for this analysis were downloaded from the class website on November 25, 2013. They are a
processed version of an open source dataset available from the UC Irvine, Machine Learning
iii
iv,v
Repository. As described in detail in several sources, researchers had subjects wear a Samsung
Galaxy S II smartphone in a waist holster while performing the activities noted in the introduction, and
data from the phone’s accelerometer and gyroscope were recorded. Data were collected from 30 different
subjects, and each subject performed several trials of each activity. For each trial, the time-domain
sensor...

...2013
Decision Modeling Assignment: Golf Course Design
CO 5124 DataAnalysis & Decision Modeling Tutorial : B By Madhumita Srinivasan (12772343) Submitted to Dr.Eddie Chng
1 |CO5124 DATAANALYSIS & DECISION MODELING
INTRODUCTION
Paradise Palm Golf Club, a well established golf club in Cairns, has planned to expand its operations by building a brand new golf course in Townsville. As the success of the golf course largely depends on the extent to which the users find it enjoyable, Future designers now face the challenge of designing an 18-hole Golf course that fits within 42 acres, that has a maximum enjoyability index. Based on the enjoyability index associated with each type of hole in the golf course, we should pick the number of holes in each category such that overall enjoyability level is at its highest. Also, Future designers have an additional option of having an extended club house, which is known to enhance user enjoyment. Two models are developed using Linear Optimization Model (LP) for each alternative, and we analyze and evaluate both the current scenarios and their impact on the overall enjoyability of the gold course’s users. Based on the findings, recommendations are provided to the management of Paradise Palm Golf Club.
2 |CO5124 DATAANALYSIS & DECISION MODELING
STEP ONE: DECISION VARIABLES
The first step towards designing a golf course...

...Also, the interest of what is hot and trending, whether it be a new flavor or a change in the bottling of a product, the customers demand is what the company must take into consideration when presenting its product to this external stakeholder.
Another external stakeholder who is vital to Coca Cola is the suppliers. The suppliers range from the materials to the packaging company play an essential role in the workings of everyday life within and around Coca Cola. Communication in and around the supply chain through management it helps to keep a well-oiled machine going. The suppliers’ interest or claim in Coca Cola is simple. With Coca Cola as one of its clients, these suppliers stand to run and make a good profit and have continuous business. The quality of the work these suppliers have must meet Coca Cola’s standards. These suppliers insure Coca Cola that their standards are up to par and are inspected. (Dione, 2010).
Competitors are another external stakeholder. Coca Cola has various competitors from Pepsi to 7up (Dione, 2010).. These competitors keep Coca Cola on their toes. The interest these external stakeholders have is making sure they are staying competitive with what Coca Cola is presenting and selling. These competitors do not want to be out sold Coca Cola. What this does for Coca Cola is it keeps them on their toes. Companies that know they have competition are creative and innovative as they try to stay one step ahead of their...

...*IS:arrangement of people,data,processes,information technology that interact to collect,process,provide as output the info needed to support the organization.
Types of IS: TPS,MIS,decision support system,communications and collaboration system,expert system, office automation system & executive info system
Types of Stakeholders:System owners (middle and executive managers, supervisors),System users (clinical& service workers,technical and professional workers; suppliers,customers,employees),System Builders (network admin,security admin,data base programmer,system programmer),System Designers (web archs,graphic artists,network architectures),External service provider (sales engineers, technology engineers, system consultants),Project manager,System analyst:is a problem solver,he/she studies business probs and opportunities,then transform them into info that will be used by technical specialists.
System analyst:specialist who studies problems and needs of an organization to determine how people,data,processes and info technology can best accomplish improvements for the business.
Skills by System Analyst:Working knowledge of information technology(The analyst must be aware of both existing and emerging information technologies),Computer programming, experience and expertise,General business knowledge,General problem-solving skills,Good interpersonal communication skills,Good...

...DataAnalysis And Design
BTEC HIGHER NATIONAL DIPLOMA
Assignment
Institute Name : IDM Computer Studies Pvt. Ltd.
Unit Name : DataAnalysis and Design
Unit : Unit 13
Assignment Title : Understanding and Analysis, Design and Implementation of
Database system.
Date given : 10th May 2010
Date to be submitted : 20th July 2010
Lecturer : Mr. T. Shanakr
Rational
The objective of this assignment is to assure that the students have gained the relevant knowledge according to the outcomes specified in the syllabus.
Assessment requirements to meet learning outcomes
1. Understand data models and database technology
2. Design a relational database to meet user requirements
3. Use manipulation and query tools and techniques
4. Implement and test database design.
ASSESSMENT CRITERIA
|Criteria for PASS |Possible evidence |Feedback |
| | |Y |N |Comments |
|P13.1.1 Provide evidence to support an | |...