Rules: 1. You should work individually 2. Use (Microsoft office) EXCEL or SPSS (

Question

Rules: 1. You should work individually 2. Use (Microsoft office) EXCEL or SPSS (Statistical Package for Social Science) to solve all the questions. . Send your answers as a softcopy into Moodle website 4 Put your ID as a name for your file and Write your name and ID inside the file s. Solve each part in one page or one sheet. Question :Descriptive Statistics (5 Marks) A manufacturer is investigating the operating life of laptop computer batteries. The following data are available. 164 45 139 126 130 Compute the following measures of location and variability: Mean, Median, Mode, Variance and Standard deviation respectively Question 2: linear Regression (5 Marks) Let's say that we had data on the prices and the actual number of sales of homes: of homes on sale of S of new 75 260 280 20 Answer all the following questions: Construct a scatter diagram with Price and Sales. (1 mark) z) Is there any relationship between Price and Sales? (1 mark) ) Compute the coefficient of correlation. (1 mark) 4 Comment on the value of the coefficient of correlation.(1 mark) s) Use the regression equation to predict Price when the Sales are 65 (1 mark)

Explanation / Answer

Question1:

In excel

Go to

Data>data analysis>descriptive statistics

Give the input range

Select summary statistics.

ANSWERS GIVEN IN BOLD

life(in min) Mean 136.85 Standard Error 1.548179 Median 132.5 Mode 126 Standard Deviation 9.791545 Sample Variance 95.87436 Kurtosis 0.079847 Skewness 0.878834 Range 39 Minimum 125 Maximum 164 Sum 5474 Count 40

Related Questions

Navigate

• Browse (All)
• Browse R
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.