IBA134 Business Statistics
OUA Study Period 4 (SP4), 2013
Computer Assignment
(Worth 15% of the overall assessment for the unit)
Due date: 5pm (QLD time) on Sunday 26, January 2014 (Week 9)
Instructions:
All numerical calculations and graphs/plots should be done using EXCEL.
A hard copy of your completed assignment must be submitted electronically with the Griffith OUA Cover Sheet (available in the Assessment section of the unit website) attached as the 1st page of your submission. See instruction on the IBA134 Business Statistics unit website under “Assessment” and “Online submission of assignments using SafeAssign” on the link
…show more content…
(b) Use five of the above summary measures to represent the summary information in a box plot for each variable. Draw the box plot (using Data Analysis Plus).
(c) Compute a numerical summary measure to measure the strength of the relationship between the two variables. Interpret this value.
QUESTION 4 The researcher considers using regression analysis to establish a linear relationship between the two variables.
(a) What is his dependent variable and independent variable? Why?
(b) Estimate a simple linear regression model and present the estimated linear equation. Interpret the coefficient estimates of the linear relationship.
(c) Interpret the R-squared (R2) value.
QUESTION 5 (Show all working in EXCEL by setting up a table) A shopping mall estimates the probability distribution of the number of stores mall customers actually enter (X), as shown below:
X 0 1 2 3 4 5 6
P(x) 0.04 0.19 0.22 0.28 2k 0.09 k
(a) Find the value of k.
(b) Find the mean of number of stores entered.
(c) Find the standard deviation of the number of stores entered.
QUESTION 6 (Use EXCEL commands to perform the calculations below and state which commands you have used in your answers – do not use the normal table)
A marketing manager of a leading firm believes that total sales for the firm next year can be modelled by using a normal
2. Based on the scale of measurement for each variable listed below, which measure of central tendency is most appropriate for describing the data?
In this case, the independent variable is the gender and the dependent variable is the
Everytime Adobe Acrobat releases an update my computer pops up with a nessage asking if I want to update it now or later. It also gives me the option to check a box for automatic updates (updating without asking my permission). I am not required to provide a disk or file.
Exercises 12.17, 12.21, and 12.43 require the use of the “Regression” function within the Data Analysis menu in Excel. Refer to Appendix E12 for instructions on using Excel for these exercises.
(22) A study was conducted in Malibu on the value of a house (Y, in thousands of dollars) as it relates to the distance the house is from the beach (X, in miles). The result was the regression equation, Y= 800-20X. In the equation, the number 20 represents.
22) Which statement is true of a regression line that is superimposed on the scatter plot?
Rather what I want you do is to highlight what you see for three individual variables (no more than 1 graph for each, one or two measures of central tendency and variability (as appropriate), and two or three sentences of interpretation). For the 10 pairings, identify and report only on three of the pairings, again using graphical and numerical summary (as appropriate), with interpretations. Please note that at least one of your pairings must include Location and at least one of your pairings must not include Location.
4) Use exponential regression (or find a constant ratio) to determine an equation for the data.
6. Using IBM® SPSS® software, create a frequency table to summarize the data on the educational level variable. Copy and paste the output from IBM® SPSS® into this worksheet.
"There are several different kinds of relationships between variables. Before drawing a conclusion, you should first understand how one variable changes with the other. This means you need to establish how the variables are related - is the relationship linear or quadratic or inverse or logarithmic or something else" ("Relationship Between Variables ", n.d)
Q7: Create a bar graph or pie chart of the data you have collected. For example, you could create a bar graph that shows the employee turnover rate in organizations that do offer flexible work arrangement compared to organizations that do not. Alternately, you could create a pie chart that shows which types of flexible work arrangement workers want the most.
Explain how regression can be used to analyse the relationship between political freedom and real GDP per capita? -Regression is be used to show whether there is a positive or negative relationship between political freedom and GDP per capita. The coefficient of b determines the slope of the line and how an increase in X affects Y. The regression also determines the R squared which shows how closely the X and Y variable are correlated within the regression. The confidence levels indicate how confident political freedom has an impact on GDP at a particular confidence level. The P value explains whether to accept the null hypothesis or to reject it.
2. What is the required output? What is the necessary input? How you will obtain the required output from the given input? Clearly describe variable names and definitions. Include all necessary formulas and
So a β value of 0.07 would mean that y changes by 7% for a one-unit increase of x. These βs then will be the main basis of our results. But we also have to have measures to see how well the equation explains the relationship be-tween the dependent variables and the independent variables. Studenmund focuses on two techniques.