Select Page

I need help completing this week’s assignment for my statistic class. It is a critical thinking assignment. Please show me how to perform the calculations on excel, such as the formulas that way I can learn. Below the questions you will find the data of the 200 cars.An expert who works for a car magazine obtained random data (rounded to the nearest thousand) among two categories of used or new cars:DomesticForeignThe expert would like to understand sales based on list price (rounded to the nearest thousand dollars), sale price (rounded to the nearest thousand dollars), and number of days it takes to sell each car. The complete data set is in the file named Cars.Managerial ReportDescriptive statistics (mean, median, range, standard deviation, and coefficient of variation) to summarize each of the three variables for the all Domestic cars. Use z-scores to determine if there any outliers in the data set for any of the three variables. If there are any outliers in any category, please list them and state for which category they are an outlier. If a result is an outlier, state whether it is below or above the mean.Descriptive statistics (mean, median, range, standard deviation, and coefficient of variation) to summarize each of the three variables for the all Foreign cars. Use z-scores to determine if there any outliers in the data set for any of the three variables. If there are any outliers in any category, please list them and state for which category they are an outlier. If a result is an outlier, state whether it is below or above the mean.Compare your summary results from #1 and #2. Discuss any specific statistical results that would help the car expert understand the car market.Develop a 98% confidence interval estimate of the population mean sales price and population mean number of days to sell for Domestic cars. What is the Margin of error? What are the lower (or left) and upper (or right) endpoints of the confidence interval? Interpret your results.Develop a 98% confidence interval estimate of the population mean sales price and population mean number of days to sell for Foreign cars. What is the Margin of error? What are the lower (or left) and upper (or right) endpoints of the confidence interval? Interpret your results.Assume the car expert requested estimates of the mean number of days to sell for the Domestic cars with a margin of error of seven days and the mean number of days of Foreign cars with a margin of error of eight days. Using 98% confidence, how large should the sample sizes be for each?Suppose a Domestic car has a list price of \$30,000 and a Foreign car has a list price of \$30,000. What is your estimate of the final selling price (based on the percent difference for the sale and list price) and number of days required to sell each of these cars?Domestic CarsForeign CarsCarList Price in KSale Price in KDays to SellList Price in KSale Price in KDays to Sell198.34036.734.13923430.255251.526323.919.34811.19.627429.728.81248.145.952526.724.1286.84.553631.231.2307.56.539722.720.22471.570.8598844221.721.751918.314.92959.559.1401043.942.91619.117.7151149.147.1236764.346128.75.41779.276.1621323.218.33029.324.9321417.113.41569.166551515.314.54063.958.9151639.735.23154.551.2461712.49.22761.456.4201842.340.35870.869.824192524.21929.228.452036.234.83026.623.9442113.912.13711.79582218.715.64312.28.5112339.536.64451.650.636242322.15548.848.4242532314033.932.4312634.933.12282.377.8512743.639.25675.971.821286.94.72844.139.7172943.641.84730.527.73530129.64456.552.319318.76.11388.38818327.25.31551.850.8463339.6364725.721.683416.516.22134.233.1423543.940.84575.875.3243647.646.2575.573.5253721.321444039.6553829.526.966766.2503918.616.2471615224046.6466050.246.1404186.11485.183.8524211.28.6137371.2224333.832.6281511.6374410.17.23012.910.6324513.913.61526.322274648.444.52829.828.5164713.513.14665.762.44486.44.24521.819.4434938.338.23744.340.595038.537.74078.677.2615136.936.4435049.2455218.614.12557.153.823534.53.14746.645.6585425.422.53882.278.6665559.957.35861.158.361564440.5538178.9355719.818.31877.175.3445812.610.12034.429.423593531.8112322.546052.249.94954.953.9576138.636.65082.281.366622423.3187974.624634544.13123.519.3286452.947.91676.272.5626552.350.6303331.5516650.947.52548.746.7496718.316.353433.8276834.329.55575.874196950.148.61735.235227057.456.44922.922.464719.26.55882.879.3297236.933.33563.863.8507341.138.23646.441.5507443.340.7658.757.8377546.842.7286463.3577651.7471187.186.1507713.38.7197570.6387857.354.3141714.4317959.654.6939.636.4138018.314.93363.862.9238142.1415925.522.2248213.89.24979.876.6278332.931.3713.111.521845452.82534.332.7498534.431.2971.268.5168623.622.64229.525.447874.74523.421.67885958.23812.69.5398926.524.53915.514169034.530.8486059.449124.520.55620.917.112923.91.93481.879.8459354.8318984.1569458.358.13038.135399533.632.11815.512.7519645.642.7960.358.4219738.834.91864.263.189835.634.24752.249.518991712284.93.3261001815.55141.341.21810158.555.45064.663.51910220.919.94849.645.64710332.532.1646.442.4411041914.43551.849541054.442778.877.66010667.667.43955.254.72110759.254.3572117.3431082521.72532.530.56710955.752.86243.543311025.723.96211.99.56511149.144.72915.110.41411267.766.32850.148.74511345416581.279.73611448.643.66383.879.13511525.925.7556865.12811637.8375054.450.81411725.720.83154.551.41211827.324.8514.91.3571196564.23030.7295012058.356.9574540.4601218.64.66220.417.4111224037332423.951233.932079.178.45312421.219.35422.818.2311253635.1236665.82412636.233.85188.185.63112767.466.3178.63.86012824211938.335.160129108.84952.149.14913036.436.41123.720.7613138.437.54667.163.33813232.7284463.461.33313311.9111145.941101348.75.51777.374.42513513.510.53346.542.62713618.314.81263.960561373.833783.281.36213867.365.3535.41.75513924.722.25396.46114029291678.274.26614112.411.45427.325.3314226.421.986762.81414324.219.27084.182.14414459556077.773.91514518.716.74051.751.43814629.628.4377974.53314746.946.5695046.11014859.957.71030.529.72914938.735.63349.849.74715035.732.24559.859.11715134.433.66017.415.7671523227.14332.131.25415322.818.14341.138.15415416.916.25654.153.15915594.22813.610.86215663.859.4464339.34515710.25.35485.882.95615852.851.84835.632.65315942.139.6222522.791609.67.2588.84.45016117.814.25941.839.5261624846.33020.419.42316367.3631160.359221642925656864.56816513.911.3496561.36616618.216.13511.39416754.953.56737.532.92216878.876.56788.387.73016910.58.41762.858.22817021.717.82471.869.2591717.97.12986.584.65317225.123.83471.867.34617322.417.52347.145.26517462.858.31889.385.71117573.168.387570.12817621.120.71869.666.81117750.846.44187.483.51617818.518.44324.722.6151794136.71173.972.61418056.953.65080.679.11518160.560.31389.1875618256.955.1425554.37118320171324.722.45718419.518.254.82.33918525.520.95384.281.81418650.4501586.983.51918773.170.84185.7813918818.515.75440.838.95118971.366.4457.253.5561906966.9266.55.54119160.857.81579.176.12919219.718.71314.612.2119321.91911.10.821949.48.62541419534.932.6584.93019621.921.31327221819727.423.31214.811.91119814.311.7154.453.6151995.23.8389.587.110020014.310.9711.57.614

#### Why Choose Us

• 100% non-plagiarized Papers
• Affordable Prices
• Any Paper, Urgency, and Subject
• Will complete your papers in 6 hours
• On-time Delivery
• Money-back and Privacy guarantees
• Unlimited Amendments upon request
• Satisfaction guarantee

#### How it Works

• Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
• Fill in your paper’s requirements in the "PAPER DETAILS" section.