Calculus and Above

# I have a question about excel problem. There are thousands…

Customer Question
Hi I have a...

Hi I have a question about excel problem

There are thousands of mutual funds available. There is no shortage of sources of information about them. Newspapers regularly report the value of each unit, mutual fund companies and brokers advertise extensively, and there are books on the subject. Many of the advertisements imply that individuals should invest in the advertiser’s mutual fund because it has performed well in the past. Unfortunately, there is little evidence to infer that past performance is a predictor of the future. However, it may be possible to acquire useful information by examining the managers of mutual funds. Several researchers have studied the issue. One project gathered data concerning the performance of 2,029 funds. The performance of each fund was measured by its risk-adjusted excess return, which is the difference between the return on investment of the fund and a return that is considered a standard. The standard is based on a variety of variables, including the risk-free rate. Four variables describe the fund manager: age, tenure (how many years the manager has been in charge), whether the manager had an MBA (1 = yes, 0 = no), and a measure of the quality of the manager’s education [the average Scholastic Achievement Test (SAT) score of students at the university where the manager received his or her undergraduate degree].
Conduct an analysis of the data. Discuss how the average SAT score of the manager’s alma mater, whether he or she has an MBA, and his or her age and tenure are related to the performance of the fund.
(Question: Is there any of four independent variables linearly related to the performance of the fund? Show your work.)

Hi can you answer my question

Submitted: 5 months ago.Category: Calculus and Above
Show More
Show Less
Customer reply replied 5 months ago
here is the attachment
10/5/2017
Tutor: Mr. Glenn, Math and Stat Expert replied 5 months ago
Mr. Glenn, Math and Stat Expert
Category: Calculus and Above
Satisfied Customers: 899
Experience: Math Professor for at least 15 yrs
Verified

Hi

Thank you for using this site, Do your teacher require you to use multiple regression analysis, or does your teacher specify a method to be used? Please reply

Tutor: Mr. Glenn, Math and Stat Expert replied 4 months ago

Hi

Do you still need help on this?

SusanAthena, Master's Degree
Category: Calculus and Above
Satisfied Customers: 102
102 Satisfied Customers
Experience: Tutor for Algebra, Geometry, Statistics. Explaining math in plain English.

SusanAthena is online now

A new question is answered every 9 seconds

• Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
• Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

## What Customers are Saying:

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here.

DianeDallas, TX

< Previous | Next >

## Meet the Experts:

SusanAthena

Master's Degree

102 satisfied customers

Tutor for Algebra, Geometry, Statistics. Explaining math in plain English.

Mr. Gregory White

Master's Degree

99 satisfied customers

M.A., M.S. Education / Educational Administration

Dr Arthur Rubin

Doctoral Degree

58 satisfied customers

Ph.D. in Mathematics, 1978, from the California Institute of Technology, over 20 published papers

JACUSTOMER-yrynbdjl-

Master's Degree

42 satisfied customers

I have a MS in Mathematics and I have taught Mathematics for 10 years at the college level.

dhouse1940

Master's Degree

33 satisfied customers

BS mathematics, MS biostatistics, 35+ yrs designing & analyzing biological experiments.

Don

Master's Degree

29 satisfied customers

M.S. Astronautical Engineering. Math/Sci/Comp Tutor

mhasan420

Master's Degree

15 satisfied customers

BA Maths, Oxford

< Previous | Next >

Related Calculus and Above Questions
I need to read a multiple regression scatterplot. i need to
i need to read a multiple regression scatterplot. i need to explain it to a doctoral committee. can u help me: Can you help me clearly explain my equation (R2 = .21, F(2, 365) = 48.5, p<0.01) in a … read more
Mr. Glenn
Math and Stat Expert
899 satisfied customers
Determine the range of values in which you would expect to
Determine the range of values in which you would expect to find the average weekly sales for the entire sales force in your company 90% of the time. Calculate the impact of increasing the confidence l… read more
Mr. Glenn
Math and Stat Expert
899 satisfied customers
I need help with my economics statistics homework. It is
I need help with my economics statistics homework. It is about confidence intervals. Thank you!… read more
Mr. Glenn
Math and Stat Expert
899 satisfied customers
I conducted a logistic regression analysis. My Chair asked
I conducted a logistic regression analysis. My Chair asked me to add the regression equation. I will include the chartTable 6 Logistic Regression: Predicting Incarceration Variable Beta coefficient Wa… read more
Mr. Glenn
Math and Stat Expert
899 satisfied customers
I have a lot of trouble with finding correlation by adding
Hi, I have a lot of trouble with finding correlation by adding n=15 two points to each of X values. There are n=15 pairs of X and Y values with Pearson correlation of r=0.40 … read more
Ashok Kumar
Master\u0027s Degree
291 satisfied customers
I need to solve those two problems for Statistics. Questions
I need to solve those two problems for Statistics. Questions 1, and question 2 … read more
Mr. Glenn
Math and Stat Expert
899 satisfied customers
The total cholesterol levels of a sample of men aged​ 35-44
The total cholesterol levels of a sample of men aged​ 35-44 are normally distributed with a mean of 225225 milligrams per deciliter and a standard deviation of 38.838.8 milligrams per deciliter.​(a) W… read more
Bachelor of Education
Looking at the winemaker question and am wondering if I came
Looking at the winemaker question and am wondering if I came to the correct solution … read more
Mr. Glenn
Math and Stat Expert
899 satisfied customers
Can you help me with these questions, they are stats
well, I need these answers asap. can you help they are the exact questions on the grid… read more
Mr. Glenn
Math and Stat Expert
899 satisfied customers
According to a report by the US Fish and Wildlife Service,
According to a report by the US Fish and Wildlife Service, the mean length of six-year-old rainbow trout in the Arolic River in Alaska is 481 millimeters with a standard deviation of 41 millimeters. A… read more
Ryan
Bachelor\u0027s Degree
1,060 satisfied customers
I am really struggling with some of my economics stats
Hi! I am really struggling with some of my economics stats homework. Can you help me? Here is the question: A normal population has a mean of 60 and a standard deviation of 3. You select a sample of 3… read more
Mr. Glenn
Math and Stat Expert
899 satisfied customers
I'm working on a statistics problem that I don't
Hi, I'm working on a statistics problem that I don't understand... In a survey of a group of​ men, the heights in the​ 20-29 age group were normally​ distributed, with a mean of 67.7 inches and a stan… read more
Mr. Glenn
Math and Stat Expert
899 satisfied customers
According to a​ study, brain weights of men in country A are
According to a​ study, brain weights of men in country A are normally distributed with mean 1.371.37 kg and standard deviation 0.160.16 kg. Apply the empirical rule to complete each sentence. Complete… read more
Mr. Glenn
Math and Stat Expert
899 satisfied customers
I'm taking a statistics quiz. I've taken this quiz 3 times
I've taken this quiz 3 times and can't pass it. applied managerial statistics … read more
Mr. Glenn
Math and Stat Expert
899 satisfied customers
A wheel with a radius of 500 mm has a mass of 35 kg and a
A wheel with a radius of 500 mm has a mass of 35 kg and a radius of gyration of 300 mm. A rope around the rim of the wheel provides a tangentle force of 2.0 N to the wheel which turns on an axle. Find… read more
Ryan
Bachelor\u0027s Degree
1,060 satisfied customers
I am new to this and I have some home work as well as
Hello I am new to this and I have some home work as well as quizzes that I need help with … read more
Mr. Glenn
Math and Stat Expert
899 satisfied customers
How much would it be to solve and show how you got the
How much would it be to solve and show how you got the solution for 15 questions. Business Statistics, Inferences and Linear Regression… read more
Mr. Glenn
Math and Stat Expert
899 satisfied customers
You helped me back in December with a Pearson Correlation. I
Hey Ryan,You helped me back in December with a Pearson Correlation.I was seeking your help in the same way with solving and describing SOME of the rationale behind the reasoning of the answer for anot… read more
Mr. Glenn
Math and Stat Expert
899 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less