Question: in Excel, In the first tab,Generate random numbers for 40 students for their age between 23 to 35 , Performance % between 40 to 100

in Excel,

In the first tab,Generate random numbers for 40 students for their age between 23 to 35 , Performance % between 40 to 100 and Weekly study hours between 2hrs to 14 hrs

3. Calculate mean for all variables

4. Calculate standard deviation for all variables

5. What is the confidence interval for population mean each variables ( level of confidence 95%)

6. Calculate coefficient of correlation, determination and regression equation for students' age and performances

7. Calculate coefficient of correlation, determination and regression equation for students' study hours and performances

8. Explain your findings

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Need Urgent Help with Question 3 and Question 9 of the attached document - Question 3 needs only ~400 words (also attaching an article which might be needed to answer question-3) My word count for...

Chrome Edit View History Bookmarks Profiles Tab Window Help 92% Sat 8:37 AM Q Final exam , Saturday 12/6/202 x Class : Sun , Tue and Thur ... final86 C...

0 Question 23 B 0/1 pt '0 3 8 99 (9 Details 14% of all college students volunteer their time. Is the percentage of college students who are volunteers larger for students receiving financial aid? Of...

Hello, Any help on the assignment below will be appreciated. Question 1: SAMPLING (Part A) Suppose you wish to evaluate the prices ( rent asked, per week ) of 1to3bedroom rental properties. Your...

Part B: Class Statistics For Part B you are to modify the worksheets in Excel that helps you keep track of the marks of a fictitious class. Part B will consist of three sheets: 1. a marks worksheet...

Instuctor's Annotated Edition TENTH EDITION Understandable Statistics Concepts and Methods Charles Henry Brase Regis University Corrinne Pellillo Brase Arapahoe Community College Australia Brazil...

Set Student Name: 1. Answer true or false for each part, and if false, explain your answer. a. The point estimate for the population mean, , of an x distribution is x-bar, computed from a random...

Florida Institute of Technology Instructions: Read the questions very carefully because the requirements for each are specific. Each group should turn in one copy of this WORD document (email to me)...

Do students reduce study time in classes where they achieve a higher midterm score? In a Journai' ofEconomic Education article (Winter 2005), Gregory Krohn and Catherine O'Connor studied student...

1 (1 point) The average battery life of the iPhone 4S is reported to be 6.0 hours. Assume that the standard deviation for the battery life for this cell phone is 36 minutes. A random sample of 42...

Your research assistant has a worried look on her face. "What's the problem?" you ask. "I goofed," she confesses. "1 thought taxes were exogenous when actually there's a marginal tax rate of .1."...

1. Theoretically, the angle of projection for maximum range is 45 degree. does this set a limit on the range? explain. 2.what affect does air resistance have on the range of the projectile? 3.what...

Evaluate log p 2 x log s p.

According to the U.S. government, it costs more to make a penny, $0.0241, than a pennys value, $0.01. The U.S. government has considered eliminating pennies from its currency. Canada and Australia...

Q2. PQR is a digital content streaming company. The company has been having constant increase in its subscriber based since its inception four years back. You are given projected Free Cash Flow to...

Use Theorem 4.4 to calculate the variance of the probability distribution in Exercise 4.12. Verify that your result agrees with Exercise 4.12. Data from Exercise 4.12 According to an August, 2011...

Joseph Randal has just been named the director of alumni relationships at a local university. Alumni donations are an important source of revenue for colleges and universities. If administrators...

Four pesticides used in dormant California orchards are chlorpyrifos, diazinon, methidathion, and parathion. Environmental Science & Technology (Oct. 1993) reported the number of applications of...

Determine if the overhead allocated to the product relates to a single plantwide overhead rate method, multiple production department factory overhead rate method, or activity-based costing...

Consider the following model for the flow of water in and out of a dam. Suppose that, during day n, Y, units of water flow into the dam from outside sources such as rainfall and river flow At the end...

Let X,.., X, be equally likely to be any of the n! permutations of (1, 2, ., n) Argue that P{X, a} = P{{X, = n(n + 1)/2-a}

Let {X(t), t 0} be a compound Poisson process with Poisson rate and component distribution F. Define a continuous-time martingale related to this process