Please use excel to find the following, thank you very much! (8) A sample of 600...

Please use excel to find the following, thank you very much!

(8) A sample of 600 Scholastic Aptitude Test (SAT) results has mean of 500 and standard deviation of 100.

a. Determine the score below which 10% of the values lie.

b. Determine the score above which 10% of the values lie.

c. Determine a 95% confidence interval for the true mean.

Expert Solution

thank you.

orchestra answered 1 year ago

PLEASE COMPUTE THE FOLLOWING IN EXCEL and show the excel sheet, Thank you so much! The...

PLEASE COMPUTE THE FOLLOWING IN EXCEL and show the excel sheet, Thank you so much! The following are the runs scored totals for 9 players for the 2016 New York Yankees: 56,43,63,68,58,80,71,32,19 (a) Find the mean and median (b) Find the standard deviation of this population (c) Considering this as a normal sample of American League players for the 2016 season, find a 99% Confidence Interval for the actual mean of Runs Scored for AL players, 2016 . (d) Considering...

FIND THE ANSWER WITH EXCEL PLEASE! THANK YOU SO MUCH! (2) The lifetime of a computer...

FIND THE ANSWER WITH EXCEL PLEASE! THANK YOU SO MUCH! (2) The lifetime of a computer circuit has an exponential distribution with mean of three years. Find the probability that a circuit lasts longer than 4 years.

Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use...

Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use the stocks of Apple, SAP, IBM, Oracle, and Amazon Download the historical data of weekly stock prices and S&P 500 index prices from year 2017-2019 on the website of yahoo finance and save it on an excel file. B. Use a different sheet to save the market adjusted prices of Apple, SAP, IBM, Oracle, and Amazon t and the index. For each stock, compute...

Please type the answer for i can copy it. Thank you very much. -Question 1 Respond...

Please type the answer for i can copy it. Thank you very much. -Question 1 Respond to the following in a minimum of 175 words: Read the following pseudocode class definitions: Class Plant Public Module message() Display "I'm a plant." End Module End Class Class Tree Extends Plant Public Module message() Display "I'm a tree." End Module End Class -Question 2 Given these class definitions, determine what the following pseudocode will display: Declare Plant p Set p = New Tree()...

PLEASE ANSWER IN EXCEL FORMAT, WITH FORMULA USED. Thank you!! 8.Consider the following three stocks: ▪Stock...

PLEASE ANSWER IN EXCEL FORMAT, WITH FORMULA USED. Thank you!! 8.Consider the following three stocks: ▪Stock A is expected to provide a dividend of $11.10 a share forever. ▪Stock B is expected to pay a dividend of $6.10 next year. Thereafter, dividend growth is expected to be 5.00% a year forever. ▪Stock C is expected to pay a dividend of $4.90 next year. Thereafter, dividend growth is expected to be 21.00% a year for five years (i.e., years 2 through...

Please use Excel and show the formula you used. Thank you :) A manufacturing process produces...

Please use Excel and show the formula you used. Thank you :) A manufacturing process produces connecting rods whose diameter is normally distributed with mean 1.495 cm and standard deviation .05 cm. In what range will the “middle 80%” of the diameters lie? What about the “middle 98%”?

Please answer a statistic problem(please answer all subquestions). Thank you very much. NCbirths, cont' d. This...

Please answer a statistic problem(please answer all subquestions). Thank you very much. NCbirths, cont' d. This time we will use a subset of the dataset after removing premature birth (36 weeks or sooner) and continue to use MomRace as the explanatory variable to predict birth weight. To get NCbirths: install.packages("Stat2Data") library(Stat2Data) data("NCbirths") (a) Use the following R command to remove premature birth and create a dataset noPremie. noPremies<-subset(NCbirths, NCbirths$Premie==0) ##subset(dataName, condition) (b) Construct a side-by-side boxplot of birth weights separated...

I want to use public transportation/paratransit in my scenario thank you very much. Journey of the...

I want to use public transportation/paratransit in my scenario thank you very much. Journey of the semester my focal point has been public transportation/paratransit can you apply the below question in that scenario thank you in regards to Learn Manufacturing, discuss why it’s important to focus on the movement of goods and services based on customer demand

PLEASE ANSWER IN EXCEL FORMAT THAT IS EASILY UNDERSTOOD ONLY, THANK YOU!! (no writing please) [EXCEL]...

PLEASE ANSWER IN EXCEL FORMAT THAT IS EASILY UNDERSTOOD ONLY, THANK YOU!! (no writing please) [EXCEL] Percent of sales: Cattail Corporation's financial statements for the fiscal year just ended are shown below: Cattail Corporation Income Statement Net Sales: $1500 Costs: $350 Net Income: $1150 Balance Sheet Assets $700 = $700 Debt $600 Equity 100 = $700 Cattail management expects sales to increase by 14 percent next year. Assume that the financial statement accounts vary directly with changes in sales and...

PLEASE ANSWER ALL 4 THANK YOU VERY MUCH!!!! 1. How was the Periodic Table originally organized?...

PLEASE ANSWER ALL 4 THANK YOU VERY MUCH!!!! 1. How was the Periodic Table originally organized? Explain the current organization of the Periodic Table and why it is a more accurate layout of the elements. 2. What is the difference between groups and periods? What are the common names for groups IA, IIA, VIIA, VIIIA? 3. Why were elements in group 18, VIIIA, formerly known as inert gases? How is the current name of “noble gases” more appropriate? Provide examples...

Question