These are 2 different assignments for my Data Analytics class. The first is just a 2 question homework. The Homework needs to have 2 separate documents 1 word document showing the answers and 1 excel...

1 answer below »
These are 2 different assignments for my Data Analytics class. The first is just a 2 question homework. The Homework needs to have 2 separate documents 1 word document showing the answers and 1 excel document showing the work and formulas. The second assignment is a case study. The case study will need to have 2 different reports as well 1 report in a word document containing the managerial report and 1 excel report showing work for all the operations. In total I will need 1 word doc and 1 excel document for EACH assignment.


Case 2 Instruction_NASCAR(1).pdf ������������� ��� ������� ��� ������������������������ ��!�"�����#��$�����%����&%'�(�����(�)���*�����+,-.,/�������0�1&���&����������2('(&���3�)�2���*�(������� �����������*&�&���4�*�2(���&������'�&�������4&�5���&����66��'�&���$�3��&�4�7��"�-����(��8�9�6�'�&���:$�.�(;�<4��(4��8�9�6�'�&���:$���4���=&��1�(=&)>�8�69#�'�&���:0�?���� ������(��4�@A$ B6$#B��3"��&��&�5���(���C�;���8*�������4(&=�(�&��D2�;&*"&�5:$��&��&�5���(���(�)��$�*&�&��&�5�&��������'�*&=�� ���&%��$���4�*&�&��&�5�&��EFG�EHI�EGJ�KL�EMNGOP�QRSTRUVO�IHMJE��"���%�&���� ��;;�)���4�96�'�&�����������4(&=�(�����*&�&���4�*&(��$�9��'�&�����������4(&=�(�����*&�&���4���)��4$���4�������4������� �'�&���*�(�����4(&=�(�����*&�&���4�&������96(4�'��&�&��0�?���44&�&�����"�4(&=�(�����;�4���;�'�(�)�&=�4� �3��2��'�&��$�����4(&=�(�����;�4�����%����;�'��(�)�&=�4�����44&�&���;�3��2��'�&��$���4�����(�)���&���(��������(4�4�6�3��2��'�&���0�W2�$�����%�X&%2%��2%3�(��*�'�&������4(&=�(�)�2;4���(��&����"�(�)������9B0�7���*�;;��&�5���3;��������4����*�(������� ��������*�(�������'�6#�4(&=�(��8+,-.,/���3�&��:0�7�����4�����(��)����&��4�&������*&��YZ[\Z]0�C;�������������4����*&��+,-.,/0� ����̂_̀_abcd_e�fbghci� 0�-2''����"�2������4����'(�4&)��j&��&�5��8@:�2�&�5���;"������2%3�(��*�'�;�������8C�;��:$������2%3�(��*��&���8j&��:$������2%3�(��*���'�*&=��*&�&�����87�'�#:$��(������2%3�(��*���'�����*&�&�����87�'� �:0�j�&)���*�������*�2(�=�(&�3;���'(�=&4�������3�����&�5;��'(�4&)��(��*��&��&�5�k�8��l:���0�!�=�;�'�������&%���4�(�5(���&����D2��&��������)���3��2��4����'(�4&)��j&��&�5��8@:�5&=��������2%3�(��*�'�;�������8C�;��:$������2%3�(��*��&���8j&��:$������2%3�(��*���'�*&=��*&�&�����87�'�#:$���4������2%3�(��*���'�����*&�&�����87�'� �:0�7����*�(�&�4&=&42�;��&5�&*&)��)����4�4&�)2���"�2(�*&�4&�5����4�)��);2�&���0�8��l:� ������������� ��� ������� ��� ���������������������� �������!����"#�$%�&� �'()�����&� �*(+,��&� �'()��� ��$���$��-���./"����0���/�$��-�����!���0���$-���"�������$�1��������0�0�-� #�1������&� �*(+,��� ��$���$��-���./"����0���/�$��-�����!���0���$-���"�������$�2�-���������-� #�1���3�!�#� �����$��/�������4��$$�����5.�������-���1���"��.$������ ����1��6�����4$�789�.$��4�:�#�$;�6��$;�&� �'();�����&� �*(+,��&�$��0�������!��.�#�$�4��0�1��1��������$1.$$�<�.��0�����4$�����1��1#.$���$��7�,=9��>��?�$���. ����-����$.#�$��0�<><$�$;��-����$��><�.���1�//����.$��4���� ����1��6�����4$�789@�:��!������������ ����������0��-���$��/�������4��$$����1��00�1����$�0����-�$��5.�������7�,=9� please make 2 documents 1 word document that just shows the answer, and 1 excel document showing the work and formulas used. please provide both word and excel document for solution. this is due thursday 10/7 @5pm central time. ����.$��4����="" ����1��6�����4$�789@�:��!������������="" ����������0��-���$��/�������4��$$����1��00�1����$�0����-�$��5.�������7�,="9�" please="" make="" 2="" documents="" 1="" word="" document="" that="" just="" shows="" the="" answer,="" and="" 1="" excel="" document="" showing="" the="" work="" and="" formulas="" used.="" please="" provide="" both="" word="" and="" excel="" document="" for="" solution.="" this="" is="" due="" thursday="" 10/7="" @5pm="" central="">
Answered 2 days AfterOct 04, 2021

Answer To: These are 2 different assignments for my Data Analytics class. The first is just a 2 question...

Atreye answered on Oct 07 2021
123 Votes
MANEGERIAL REPORT
Solution 1:
After performing regression analysis for Winnings ($) based upon the predictors Poles, Wins, T
op 5 and Top 10 each at a time, the R-squared values are tabulated as below:
    Predictors
    R-squared
    Poles
    0.141903929
    Wins
    0.437664768
    Top 5
    0.74161027
    Top 10
    0.805966178
The highest –squared value is 0.805966178 which corresponds to the predictor variable Top 10. Therefore, it can be concluded that the Top 10 variable is the best single predictor of winnings.
Solution 2:
The regression equation for predicting Winnings using the predictors Poles, Wins, Top 5 and Top 10 is obtained as below:
    SUMMARY OUTPUT
    
    
    
    
    
    
    
    
    
    Regression Statistics
    
    
    
    
    Multiple R
    0.905815425
    
    
    
    
    R Square
    0.820501584
    
    
    
    
    Adjusted R Square
    0.796568462
    
    
    
    
    Standard Error
    581361.0804
    
    
    
    
    Observations
    35
    
    
    
    
    
    
    
    
    
    
    ANOVA
    
    
    
    
    
     
    df
    SS
    MS
    F
    Significance F
    Regression
    4
    4.63481E+13
    1.1587E+13
    34.2830985
    8.61007E-11
    Residual
    30
    1.01394E+13
    3.37981E+11
    
    
    Total
    34
    5.64875E+13
     
     
     
    
    Coefficients
    Standard Error
    t Stat
    P-value
    Lower 95%
    Upper 95%
    Lower 95.0%
    Upper...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here