Description
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Slope(b) = (NΣXY - (ΣX)(ΣY)) / (NΣX2 - (ΣX)2), here N =6
= ((6)*(109.4)-(7.7)*(90))/((6)*(1420)-(90)^2)
=-0.087
Please appreciate my help by selecting my answer as the best! Thanks! :)
Completion Status:
100%
Review
Review
Anonymous
Awesome! Made my life easier.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
Strayer University Week 7 Lazer Company Hypothesis Testing Discussion
WEEK 7 ACTIVITY - HYPOTHESIS TESTINGDUE NOVEMBER 22, 2021
Hypothesis Testing
The Lazer Company has a contract to produce a ...
Strayer University Week 7 Lazer Company Hypothesis Testing Discussion
WEEK 7 ACTIVITY - HYPOTHESIS TESTINGDUE NOVEMBER 22, 2021
Hypothesis Testing
The Lazer Company has a contract to produce a part for Boeing Corporation that must have an average diameter of 6 inches and a standard deviation of 0.10 inch. The Lazer Company has developed a process that will meet the specifications with respect to the standard deviation, but it is still trying to meet the mean specifications. A test run (considered a random sample) of parts was produced, and the company wishes to determine whether this latest process that produced the sample will produce parts meeting the requirement of an average diameter equal to 6 inches.
Use Excel to:
Construct the appropriate null and alternative hypotheses with correct parameters.
Develop the decision rule assuming that the sample size is 200 parts and the significance level is 0.01.
In a Word document:
Recommend what the Lazer Company should conclude if the sample mean diameter for the 200 parts is 6.03 inches.
QMB 2100 Florida State College at Jacksonville Morningstar Mutual Funds Discussion
The Morningstar mutual-fund rating system ranks mutual funds, using one to five stars. The stars divide the mutual-fund pe ...
QMB 2100 Florida State College at Jacksonville Morningstar Mutual Funds Discussion
The Morningstar mutual-fund rating system ranks mutual funds, using one to five stars. The stars divide the mutual-fund performances into quintiles: that is, a mutual fund with a one-star rating is in the bottom 20% of mutual funds in its category, a mutual fund with two-stars is in between the 21st and 40th percentile, and so on. These data can be found at www.morningstar.com (Links to an external site.) or screen.yahoo.com/funds.html (Links to an external site.)Obtain a random sample of at least 15 mutual funds from each investment category. Determine the 3 years rate of return for each fund.Obtain a 95% confidence interval for the difference between the mean rates of return. Interpret the interval.You are going to write a report detailing which investment category seems superior.The report contains 4-5 paragraphs in Microsoft Word (.doc or .docx) format with supporting data supporting your conclusion.Attach the Excel sheet used for the primary data source. You’ll submit both the Word document and the Excel file.SubmissionThis assignment requires a file upload submission (Links to an external site.). After you have reviewed the assignment instructions and rubric, as applicable, complete your submission by selecting the Submit Assignment button next to the assignment title.RubricProject RubricProject RubricCriteriaRatingsPtsThis criterion is linked to a Learning OutcomeContent30.0 to >26.0 ptsExemplaryAll required elements are fully addressed, easily identified, and integrated into the assignment at the highest level. All key facts are clearly identified and completely addressed.26.0 to >17.0 ptsMeets ExpectationsAll required elements are addressed and identified. Several key facts are identified and completely addressed.17.0 to >9.0 ptsDevelopingRequired elements are addressed, but further elaboration is needed. A few key facts are identified and addressed.9.0 to >0.0 ptsNoviceFew of the required elements are addressed. Little or no elaboration present.0.0 ptsNot AcceptableAssignment not submitted, submitted late OR contains plagiarized content.30.0 ptsThis criterion is linked to a Learning OutcomeData Source30.0 to >26.0 ptsExemplaryOriginal data provided and summarized in appropriate tabular form and is presented in a neat and accurate way graphically or numerically26.0 to >17.0 ptsMeets ExpectationsOriginal data provided and summarized in tabular form, but with a minor error in tabulation or computation or presentation.17.0 to >9.0 ptsDevelopingOriginal data is provided, with quite a few errors when summarizing data either graphically or numerically or data is not appropriately tabulated.9.0 to >0.0 ptsNoviceOriginal data is provided, tabulated and summarized but with some major errors.0.0 ptsNot AcceptableOriginal data is not provided.30.0 ptsThis criterion is linked to a Learning OutcomeTechnical40.0 to >34.0 ptsExemplaryDemonstrates excellent problem solving competency using mathematics, quantitative reasoning and statistical analysis and methods. All relevant statistics reported and correctly interpreted. Composition is structured logically, focused, well organized, and flows well.34.0 to >27.0 ptsMeets ExpectationsDemonstrates good problem solving competency using mathematics, quantitative reasoning and statistical analysis and methods.. All relevant statistics reported and correctly interpreted. Composition is structured logically, focused, organized, yet minor errors in format exist.27.0 to >17.0 ptsDevelopingDemonstrates inadequate problem solving competency using mathematics, quantitative reasoning and statistical analysis and methods.. Most of relevant statistics reported and correctly interpreted. Composition is, generally, structured logically, focused, organized, and flows well with but a few errors in format exist.17.0 to >4.0 ptsNoviceDemonstrates poor problem solving competency using mathematics, quantitative reasoning and statistical analysis and methods.. Most of relevant statistics reported yet incorrectly interpreted. Composition is, generally, structured logically, focused, organized, but major errors in format exist.4.0 to >0 ptsNot AcceptableConfusing explanation of statistical concepts.40.0 ptsThis criterion is linked to a Learning OutcomeData Interpretation30.0 to >26.0 ptsExemplaryThorough and accurate interpretation of the data26.0 to >17.0 ptsMeets ExpectationsCorrect and good interpretation of the data.17.0 to >9.0 ptsDevelopingCorrect and good interpretation of the data, except for minor errors or omissions.9.0 to >0.0 ptsNoviceInterpretation of the meaning of the data is provided, but with some major errors.0.0 ptsNot AcceptableNo data interpretation provided30.0 ptsThis criterion is linked to a Learning OutcomeReport Writing30.0 to >26.0 ptsExemplaryFollows APA writing style and basic rules of formal English grammar and written essay style. Communicates in a cohesive, logical style.26.0 to >19.0 ptsMeets ExpectationsMostly follows APA writing style and basic rules of formal English grammar and written essay style. Mostly communicates in a cohesive, logical style.19.0 to >12.0 ptsDevelopingAPA writing style and basic rules of formal English grammar and written essay style are followed, but with minor errors. Mostly communicates in a cohesive, logical style though at times ideas are unclear and confusing.12.0 to >5.0 ptsNoviceAPA writing style and basic rules of formal English grammar and written essay style are followed, but with major errors. Report is not communicated in a cohesive, logical style. Ideas are unclear and confusing.5.0 to >0 ptsNot AcceptableDoes not follow APA writing style and basic rules of formal English grammar and written essay style.30.0 ptsTotal Points: 160.0
Similar Content
Statistics Excel and a word document explanation
1. Prepare an Excel® spreadsheet containing the following:Column 1 - selected state countiesColumn 2 - population 20...
just a quick answer is all I need please
(1/1)=My brother keeps sending this to me.I don't understand this type of math...
There is more to this question.
Your basal metabolic rate is the amount of energy (in calories) your body needs to function at rest. The Ha...
Western Connecticut State University Rocket Quandary Algebra Project
Please answer all of the questions that I attachted in the file below. All work must be shown, and if the question says to...
PLZ, WILL PAY ALOT!!!!!!!!!
...
Let G be the following directed graph.
...
Probability 337 1 .edited
To take a deep dive into black men growing up in black communities and looking at the probability of them being incarcerat...
Statistics
The trend is linear. It is positive and strong until age 24. After 24, the trend becomes This trend is positive. Students ...
Ans3
The triangle formed by the rope, water and dock pillar is a right triangle. The sine of angle θ in...
Related Tags
Book Guides
Frankenstein
by Mary Shelley
A Wrinkle as Time
by Madeleine L'Engle
Don Quixote
by Miguel de Cervantes
Dead Poets Society
by Nancy Horowitz Kleinbaum
The Handmaids Tale
by Margaret Atwood
Crime and Punishment
by Fyodor Dostoyevsky
The Joy Luck Club
by Amy Tan
The Grapes of Wrath
by John Steinbeck
Jane Eyre
by Charlotte Brontë
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
Strayer University Week 7 Lazer Company Hypothesis Testing Discussion
WEEK 7 ACTIVITY - HYPOTHESIS TESTINGDUE NOVEMBER 22, 2021
Hypothesis Testing
The Lazer Company has a contract to produce a ...
Strayer University Week 7 Lazer Company Hypothesis Testing Discussion
WEEK 7 ACTIVITY - HYPOTHESIS TESTINGDUE NOVEMBER 22, 2021
Hypothesis Testing
The Lazer Company has a contract to produce a part for Boeing Corporation that must have an average diameter of 6 inches and a standard deviation of 0.10 inch. The Lazer Company has developed a process that will meet the specifications with respect to the standard deviation, but it is still trying to meet the mean specifications. A test run (considered a random sample) of parts was produced, and the company wishes to determine whether this latest process that produced the sample will produce parts meeting the requirement of an average diameter equal to 6 inches.
Use Excel to:
Construct the appropriate null and alternative hypotheses with correct parameters.
Develop the decision rule assuming that the sample size is 200 parts and the significance level is 0.01.
In a Word document:
Recommend what the Lazer Company should conclude if the sample mean diameter for the 200 parts is 6.03 inches.
QMB 2100 Florida State College at Jacksonville Morningstar Mutual Funds Discussion
The Morningstar mutual-fund rating system ranks mutual funds, using one to five stars. The stars divide the mutual-fund pe ...
QMB 2100 Florida State College at Jacksonville Morningstar Mutual Funds Discussion
The Morningstar mutual-fund rating system ranks mutual funds, using one to five stars. The stars divide the mutual-fund performances into quintiles: that is, a mutual fund with a one-star rating is in the bottom 20% of mutual funds in its category, a mutual fund with two-stars is in between the 21st and 40th percentile, and so on. These data can be found at www.morningstar.com (Links to an external site.) or screen.yahoo.com/funds.html (Links to an external site.)Obtain a random sample of at least 15 mutual funds from each investment category. Determine the 3 years rate of return for each fund.Obtain a 95% confidence interval for the difference between the mean rates of return. Interpret the interval.You are going to write a report detailing which investment category seems superior.The report contains 4-5 paragraphs in Microsoft Word (.doc or .docx) format with supporting data supporting your conclusion.Attach the Excel sheet used for the primary data source. You’ll submit both the Word document and the Excel file.SubmissionThis assignment requires a file upload submission (Links to an external site.). After you have reviewed the assignment instructions and rubric, as applicable, complete your submission by selecting the Submit Assignment button next to the assignment title.RubricProject RubricProject RubricCriteriaRatingsPtsThis criterion is linked to a Learning OutcomeContent30.0 to >26.0 ptsExemplaryAll required elements are fully addressed, easily identified, and integrated into the assignment at the highest level. All key facts are clearly identified and completely addressed.26.0 to >17.0 ptsMeets ExpectationsAll required elements are addressed and identified. Several key facts are identified and completely addressed.17.0 to >9.0 ptsDevelopingRequired elements are addressed, but further elaboration is needed. A few key facts are identified and addressed.9.0 to >0.0 ptsNoviceFew of the required elements are addressed. Little or no elaboration present.0.0 ptsNot AcceptableAssignment not submitted, submitted late OR contains plagiarized content.30.0 ptsThis criterion is linked to a Learning OutcomeData Source30.0 to >26.0 ptsExemplaryOriginal data provided and summarized in appropriate tabular form and is presented in a neat and accurate way graphically or numerically26.0 to >17.0 ptsMeets ExpectationsOriginal data provided and summarized in tabular form, but with a minor error in tabulation or computation or presentation.17.0 to >9.0 ptsDevelopingOriginal data is provided, with quite a few errors when summarizing data either graphically or numerically or data is not appropriately tabulated.9.0 to >0.0 ptsNoviceOriginal data is provided, tabulated and summarized but with some major errors.0.0 ptsNot AcceptableOriginal data is not provided.30.0 ptsThis criterion is linked to a Learning OutcomeTechnical40.0 to >34.0 ptsExemplaryDemonstrates excellent problem solving competency using mathematics, quantitative reasoning and statistical analysis and methods. All relevant statistics reported and correctly interpreted. Composition is structured logically, focused, well organized, and flows well.34.0 to >27.0 ptsMeets ExpectationsDemonstrates good problem solving competency using mathematics, quantitative reasoning and statistical analysis and methods.. All relevant statistics reported and correctly interpreted. Composition is structured logically, focused, organized, yet minor errors in format exist.27.0 to >17.0 ptsDevelopingDemonstrates inadequate problem solving competency using mathematics, quantitative reasoning and statistical analysis and methods.. Most of relevant statistics reported and correctly interpreted. Composition is, generally, structured logically, focused, organized, and flows well with but a few errors in format exist.17.0 to >4.0 ptsNoviceDemonstrates poor problem solving competency using mathematics, quantitative reasoning and statistical analysis and methods.. Most of relevant statistics reported yet incorrectly interpreted. Composition is, generally, structured logically, focused, organized, but major errors in format exist.4.0 to >0 ptsNot AcceptableConfusing explanation of statistical concepts.40.0 ptsThis criterion is linked to a Learning OutcomeData Interpretation30.0 to >26.0 ptsExemplaryThorough and accurate interpretation of the data26.0 to >17.0 ptsMeets ExpectationsCorrect and good interpretation of the data.17.0 to >9.0 ptsDevelopingCorrect and good interpretation of the data, except for minor errors or omissions.9.0 to >0.0 ptsNoviceInterpretation of the meaning of the data is provided, but with some major errors.0.0 ptsNot AcceptableNo data interpretation provided30.0 ptsThis criterion is linked to a Learning OutcomeReport Writing30.0 to >26.0 ptsExemplaryFollows APA writing style and basic rules of formal English grammar and written essay style. Communicates in a cohesive, logical style.26.0 to >19.0 ptsMeets ExpectationsMostly follows APA writing style and basic rules of formal English grammar and written essay style. Mostly communicates in a cohesive, logical style.19.0 to >12.0 ptsDevelopingAPA writing style and basic rules of formal English grammar and written essay style are followed, but with minor errors. Mostly communicates in a cohesive, logical style though at times ideas are unclear and confusing.12.0 to >5.0 ptsNoviceAPA writing style and basic rules of formal English grammar and written essay style are followed, but with major errors. Report is not communicated in a cohesive, logical style. Ideas are unclear and confusing.5.0 to >0 ptsNot AcceptableDoes not follow APA writing style and basic rules of formal English grammar and written essay style.30.0 ptsTotal Points: 160.0
Earn money selling
your Study Documents