QuestionQuestion

Transcribed TextTranscribed Text

Student Midterm Final Exam Place scatter plot beginnin in E2, expand to N22 1 76 65 2 84 90 3 79 68 4 88 84 5 76 61 6 66 79 7 77 73 8 94 93 9 66 60 10 92 86 11 80 53 12 87 83 13 86 55 14 63 72 15 92 87 16 75 89 17 69 81 18 92 94 19 79 78 20 60 71 21 68 84 22 71 74 23 61 74 Midterm = 75 24 68 54 Final Prediction = 25 76 94 You should create an equation for the prediction 26 72 79 27 99 89 28 58 53 29 82 78 30 72 82 31 77 69 32 95 98 33 72 93 34 71 80 35 72 82 36 96 96 37 72 61 38 89 84 39 94 97 40 85 89 41 60 72 42 66 93 43 96 84 44 83 87 45 88 99 46 92 97 47 78 92 48 85 93 49 91 78 50 74 82 51 96 99 52 80 72 53 62 79 54 70 75 55 87 90 56 89 95 Price Demand Place scatter plot beginnin in D2, expand to L22 $11.00 2180 $13.00 2020 $15.00 1980 $17.00 1900 Which Trendline model is best? Enter the name of the best trendline model. X Y Place scatter beginning in D2 and expand to K20 1 -102.8 1.5 -36.4 2 -4.7 2.5 -17.0 3 -5.3 3.5 -4.2 4 -1.5 4.5 -0.2 5 0.0 5.5 0.1 6 0.8 6.5 3.4 7 9.1 7.5 9.5 8 22.5 8.5 54.9 9 103.8 9.5 142.0 10 25.2 10.5 193.2 X Y Place scatter beginning in D24 and expand to K64 10 16.04 10.5 13.46 11 13.46 11.5 11.70 12 13.36 12.5 11.74 13 10.63 13.5 11.05 14 11.35 14.5 10.04 15 11.14 15.5 11.04 16 11.31 16.5 10.56 17 10.89 17.5 9.00 18 8.18 18.5 8.71 19 7.41 19.5 7.62 20 5.13 X Y Place scatter beginning in D47 and expand to K43 1 3.45 2 4.39 3 6.22 4 7.58 5 9.62 6 8.25 7 6.96 8 11.20 9 12.74 10 16.26 11 15.12 12 29.33 13 35.78 14 44.23 15 34.53 16 62.13 17 54.54 18 62.02 19 110.62 Pre MBA Post MBA Age Salary Salary Place your scatter plot beginning in E2 30 $85,000 $105,000 and expand to L20. Include a linear 34 $87,000 $100,000 trend model, equation and R². 28 $70,000 $100,000 35 $95,000 $125,000 Answer: 23 $52,000 $60,000 28 $47,000 $70,000 39 $70,000 $130,000 26 $55,000 $75,000 30 $75,000 $110,000 24 $50,000 $80,000 23 $42,500 $85,000 28 $70,000 $90,000 28 $55,000 $70,000 27 $60,000 $90,000 26 $65,000 $80,000 31 $90,000 $110,000 35 $87,000 $105,000 39 $110,000 $125,000 24 $37,000 $70,000 30 $60,000 $75,000 35 $73,000 $95,000 Place your scatter plot beginning in E23 28 $57,000 $75,000 and expand to L41. 23 $45,000 $80,000 Include a polynomial degree 3 trend model, equation and R². 29 $65,000 $90,000 33 $85,000 $100,000 Couple's Income Bride's age Wedding cost Attendance Value Rating $98,000 27 $47,000 150 3 $72,000 29 $42,000 200 5 $90,000 28 $30,500 150 3 $43,000 19 $30,000 250 3 $100,000 30 $30,000 300 3 $78,000 35 $26,000 200 5 $75,000 27 $24,000 200 5 $53,000 31 $14,000 100 1 $45,000 32 $5,000 50 5 $130,000 22 $60,700 300 3 $157,000 23 $52,000 350 1 $86,000 25 $34,000 250 3 $65,000 24 $28,000 250 3 $73,000 25 $25,000 150 5 $64,000 25 $24,000 200 1 $75,000 25 $20,000 200 5 $67,000 30 $20,000 200 5 $75,000 19 $19,000 150 3 $52,000 23 $19,000 200 1 $64,000 22 $18,000 150 1 $55,000 28 $16,000 100 5 $62,000 24 $13,000 150 1 $40,000 26 $7,000 50 3 $67,000 27 $22,000 200 5 $62,000 21 $20,000 100 1 Place first scatter beginning in G2 and expand to N20. Place first scatter beginning in G22 and expand to N62. Place first scatter beginning in G44 and expand to N41.

Solution PreviewSolution Preview

These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.

    By purchasing this solution you'll be able to access the following files:
    Solution.xlsx.

    $15.00
    for this solution

    PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

    Find A Tutor

    View available Advanced Statistics Tutors

    Get College Homework Help.

    Are you sure you don't want to upload any files?

    Fast tutor response requires as much info as possible.

    Decision:
    Upload a file
    Continue without uploading

    SUBMIT YOUR HOMEWORK
    We couldn't find that subject.
    Please select the best match from the list below.

    We'll send you an email right away. If it's not in your inbox, check your spam folder.

    • 1
    • 2
    • 3
    Live Chats