Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 62 views

    Lab 3

    Uploaded by

    Hoàng Kiều
    The document contains summaries of multiple labs covering topics such as supplier matching, loan interest rates, college completion rates, transaction data, and regression models. Key details include interest rates ranging from 6-26%, SAT scores predicting around a 59% college completion rate, highest transaction outliers of $3699 and $688, and regression models for predicting online transaction amounts and effects of payment methods.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Lab 3

    Uploaded by

    Hoàng Kiều
    62 views10 pages
    The document contains summaries of multiple labs covering topics such as supplier matching, loan interest rates, college completion rates, transaction data, and regression models. Key details include interest rates ranging from 6-26%, SAT scores predicting around a 59% college completion rate, highest transaction outliers of $3699 and $688, and regression models for predicting online transaction amounts and effects of payment methods.

    Original Description:

    lnxka

    Original Title

    Lab3

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains summaries of multiple labs covering topics such as supplier matching, loan interest rates, college completion rates, transaction data, and regression models. Key details include interest rates ranging from 6-26%, SAT scores predicting around a 59% college completion rate, highest transaction outliers of $3699 and $688, and regression models for predicting online transaction amounts and effects of payment methods.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    62 views10 pages

    Lab 3

    Uploaded by

    Hoàng Kiều
    The document contains summaries of multiple labs covering topics such as supplier matching, loan interest rates, college completion rates, transaction data, and regression models. Key details include interest rates ranging from 6-26%, SAT scores predicting around a 59% college completion rate, highest transaction outliers of $3699 and $688, and regression models for predicting online transaction amounts and effects of payment methods.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 10

    Lab 3-1

    OQ1.Which supplier is a likely match for a Sláinte employee? I got Bobs Repair as the best match
    for Slainte
    Lab 3-2

    OQ1.Interest rates on loans from this period range from 6 percent to 26 percent. Hover over a
    single value in the top-right cluster. What interest rate is assigned tothis value? When we Place our
    cursor over the data point in the top-right cluster of your cluster analysis tool (such as Power BI or
    Tableau) to see the interest rate associated with that particular value. The precise interest rate may
    change based on the dataset you use.

    OQ2. Would you expect interest rates for loans that appear in the bottom-left cluster to be high
    (closer to 26 percent) or low (closer to 6 percent)? Loans in the bottom-left cluster should typically
    have interest rates that are closer to 6%.But, you ought to verify this by examining the real data
    points contained in that cluster.

    OQ3. How many clusters have five or more different interest rates assigned to them? You must
    count the clusters in your cluster analysis results that satisfy this requirement in order to ascertain
    the number of clusters that have five or more distinct interest rates assigned to them.
    Lab 3-3

    OQ1. What is the value of the coefficient of determination (R2)?It is 0.6424 which meansthe
    regression model explains 64.24% of the variation in the college completion rate.

    OQ2. Does SAT Average appear to be predictive of college completion rate? The correlation
    coefficient between the two variables is 0.8015, indicating a strong positive correlation, suggesting
    that the SAT average can indeed predict the college completion rate.

    OQ3. What is the probability of college completion for a student with an SAT score of 1100?

    We can use the regression model to predict a student's likelihood of finishing college if they have a
    SAT score of 1100.

    The regression model's equation is as follows:=-0.57417+0.00106 * SAT average

    Upon entering a SAT score of 1100, the anticipated college completion rate is as follows:=-
    0.57417+0.00106*1100=0.5918

    Consequently, the likelihood that a student with a SAT score of 1100 will graduate from college is
    0.5918.
    Lab 3-4

    QQ1. Field has the highest avarage: 34.88721

    OQ2. The maximum for ORIG_PRICE: 2195

    OQ3. The maximum for SALE_PRICE: 3699


    Lab 3-5

    Part 1

    OQ1. What is the highest outlier from the in-person transactions? 3699

    OQ2. What is the highest outlier for online transactions? 688

    OQ3. What is the median transaction for in-person transactions? 14.99

    OQ4. What is the median transaction for online transactions? 17

    Part 2

    OQ1. What is the p-value for the one-tailed test? 0


    OQ2. Using an alpha of 0.05 (5 percent), should you reject or fail to reject the null hypothesis?
    Reject

    Lab 3-6

    Part 1

    OQ1. Using the regression formula, what is the predicted amount a customer will spend on an
    online transaction? TRAN _AMT= 15573* Online dummy + 2371535

    OQ2. What is the R Square value? R^2: 0.008727

    OQ3. What is the p-value provided for the explanatory variable? p-value provided: 0

    OQ4. If you completed the Excel track, what is the Significance F value? The significance F: 0
    Part 2

    OQ1. What is the coefficient for the BANK-Dummy variable? Coefficient for the BANK-Dummy
    variable: 0.736404

    OQ2. What is the coefficient for the Online-Dummy variable? Coefficient for the Online-Dummy
    variable: 15.44238

    OQ3. What is the expected transaction amount for a customer who uses their credit card for an
    online purchase? 23.28826v

    You might also like