Question

In: Statistics and Probability

Use StatCrunch and/or Excel (or another software of your choosing) to create a table of summary...

Use StatCrunch and/or Excel (or another software of your choosing) to create a table of summary statistics for all Quantitative variables in the Cleaned Student Data Survey Results that you submitted for Course Project 3. The table should include the following summary statistics:

n (count)

Mean

Standard Deviation

5-Number-Summary (Min, First Quartile, Median, Third Quartile, Maximum)

Range (= Max - Min)

Inter-Quartile Range (IQR = Q3 - Q1)

The table should include these summary statistics for the following variables: Age, Height (in), Shoe Size, TV, Credits, Sleep, Work, Songs, Facebook Friends, Social Media Checks, tattoos number, and Siblings. I would recommend the following format.Bounds for Outliers (Lower Bound = Mean - 2.5 * Standard Deviation, Upper Bound = Mean + 2.5 * Standard Deviation)

What is your age? With which gender do you most identify? What is your birth month? What is your height in inches? What is your shoe size? What is your eye color? How many hours of TV (movies streaming etc.) did you watch last night? How many credit hours you are currently taking? How many hours of sleep did you get last night? How many hours did you work last week? How many songs do you have on your digital music player? How many friends do you have on Facebook? How many times per day do you check social media sites? How many tattoos do you have? How many siblings do you have? What time do you usually go to bed? Rate your level of math anxiety. Who is your cell phone carrier?
47 Male October 72 11 Brown 1 15 7 50 50 34 2 0 6 23:30 None T-Mobile
22 Male June 71 12 Blue 0 14 8 30 2000 0 0 0 8 21:00 None T-Mobile
18 Male July 76 14 Blue 1 16 6 0 500 300 20 0 5 23:30 Low Verizion
22 Female August 64 8.5 Hazel 4 21 4.5 0 0 635 8 0 1 10:30 Low Verizion
20 Male November 68.6 285 Brown 0 16 8 3 290 0 30 0 2 0:30 Low T-Mobile
19 Female February 65 9 Blue 0 19 6.5 10 46 273 30 1 1 23:00 High T-Mobile
19 Male September 70 10 Hazel 3 12 7 0 143 321 0 2 1:30 Low At&T

Solutions

Expert Solution

Quantitative variables are:

Age, Height (in), Shoe Size, TV, Credits, Sleep, Work, Songs, Facebook Friends, Social Media Checks, tattoos number, and Siblings.

Hence there are no outlier.


Related Solutions

Constitutional Law You will use one of the websites (or another of your choosing) listed below...
Constitutional Law You will use one of the websites (or another of your choosing) listed below to find a law case to write about using the appropriate topic for the chosen week. Please review the grading rubric for more information on the components of the legal brief. Requirements of submission: Legal brief assignments must follow these formatting guidelines: double spacing, 12-point Times New Roman font, one-inch margins, and discipline-appropriate citations. Page length requirements: 2 pages (minimum). Please upload as a...
Bond Amortization and adjusting entry. Use excel to create an amortization table for 10 years and...
Bond Amortization and adjusting entry. Use excel to create an amortization table for 10 years and show the adjusting entry for the bond payable for the June payment. Show calculations. Had issued $1,500,000 of 4%, 10-year bond, dated 1/1/18 for $1,383,079 when the market rate was 5%. Interest is paid on June 30 and January 1 using the effective interest rate method. The June payment is included in the Dec. 1 TB. Trial Balance December 1, 2021 Description Debit Credit...
Instructions: You must use Excel or a similar statistical software package, such as SPSS, for your...
Instructions: You must use Excel or a similar statistical software package, such as SPSS, for your assignment. Tasks: 1.Select thirty stocks (at least 3 different industries) that are listed on the Toronto Stock Exchange. 2.Track each stock’s closing price at the end of the trading day. These closing prices will appear on the Internet. Collect the stock closing price data from January 2017 to December 2019. 4. For each stock, use your data to calculate and interpret: (show calculations) a)the...
Create an Excel spreadsheet or use the project template to show your computations for the first...
Create an Excel spreadsheet or use the project template to show your computations for the first 10 ratios listed for Apple Inc. and Alphabet Inc., in 2017. Supporting calculations must be shown either as a formula or as text typed into a different cell. Earnings per share of common stock (as given in the income statement) current ratio (current assets divided by current liabilities) gross profit rate (gross profit divided by net sales) profit margin (net income divided by net...
Using your preferred technology format (StatCrunch, Statdisk, Excel), generate a scatterplot for these two data sets....
Using your preferred technology format (StatCrunch, Statdisk, Excel), generate a scatterplot for these two data sets. Based on the graph, do you believe the two sets are correlated? Now, complete a hypothesis test to test the claim that the course rating and the professor rating are correlated. Explain your conclusion in statistical and non-statistical terms and how you arrived at that conclusion. You should include your null and alternative hypothesis (in English and in symbolic form), your significance level, whether...
The worksheet title “Table 1” in the Excel file “Dayton Software Inc Table 1” provides an...
The worksheet title “Table 1” in the Excel file “Dayton Software Inc Table 1” provides an overview of the market research data K2 generated. The table shows the four market segments, the anticipated size of each segment, and each segment’s willingness to pay for the two different versions of Integrated. It also includes projected costs of production and marketing. You can see the estimated production completion cost for each version, the variable cost per unit sold for each version and...
Summary Lewis wants you to write another script that shows a table of events at the...
Summary Lewis wants you to write another script that shows a table of events at the Lyman Hall Theater over the next two weeks from the current date. He has already created three arrays for use with the script: The eventDates array containing a list of dates and times at which theater events are scheduled. The eventDescriptions array containing the description of those events. The eventPrices array containing the admission prices of those events. Lewis has already written the page...
WRITE CODE IN JAVA it is now your turn to create a program of your choosing....
WRITE CODE IN JAVA it is now your turn to create a program of your choosing. If you are not sure where to begin, think of a task that you repeat often in your major that would benefit from a program. For example, chemistry unit conversions, finding the area for geometric shapes, etc. You can also create an interactive story that changes based on the user input/decisions. The possibilities are endless. The program must include instructions for the user. Be...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A firm that is in the 35% tax bracket forecasts that it can retain $4 million of new earnings plans to raise new capital in the following proportions: 60% from 30-year bonds with a flotation cost of 4% of face value. Their current bonds are selling at a price of 91...
create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel...
create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A company is evaluating the purchase of a machine to improve product quality and output levels. The new machine would cost $1.6 million and would be depreciated for tax purposes using the straight-line method over an estimated six-year life to its expected salvage value of $100,000. The new machine would require...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT