Open the files for the Course Project and the data set.

For each of the five variables, process, organize, present, and summarize the data. Analyze each variable by itself using graphical and numerical techniques of summarization. Use Excel as much as possible, explaining what the results reveal. Some of the following graphs may be helpful: stem-leaf diagram, frequency/relative frequency table, histogram, boxplot, dotplot, pie chart, and bar graph. Caution: not all of these are appropriate for each of these variables, nor are they all necessary. More is not necessarily better. In addition, be sure to find the appropriate measures of central tendency, the measures of dispersion, and the shapes of the distributions (for the quantitative variables) for the above data. Where appropriate, use the five number summary (the Min, Q1, Median, Q3, Max). Once again, use Excel as appropriate, and explain what the results mean. Analyze the connections or relationships between the variables. There are 10 possible pairings of two variables. Use graphical as well as numerical summary measures. Explain the results of the analysis. Be sure to consider all 10 pairings. Some variables show clear relationships, whereas others do not. Report Requirements From the variable analysis above, provide the analysis and interpretation for three individual variables. This would include no more than one graph for each, one or two measures of central tendency and variability (as appropriate), the shapes of the distributions for quantitative variables, and two or three sentences of interpretation. For the 10 pairings, identify and report only on three of the pairings, again using graphical and numerical summary (as appropriate), with interpretations. Please note that at least one pairing must include a qualitative variable, and at least one pairing must not include a qualitative variable. Prepare the report in Microsoft Word, integrating graphs and tables with text explanations and interpretations. Be sure to include graphical and numerical back up for the explanations and interpretations. Be selective in what is included in the report to meet the requirements of the report without extraneous information. All DeVry University policies are in effect, including the plagiarism policy. Project Part A report is due by the end of Week 2. Project Part A is worth 100 total points. See the grading rubric below. Submission: The report, including all relevant graphs and numerical analysis along with interpretations Format for report: Brief Introduction Discuss the first individual variable, using graphical, numerical summary and interpretation. Discuss the second individual variable, using graphical, numerical summary and interpretation. Discuss the third individual variable, using graphical, numerical summary and interpretation. Discuss the first pairing of variables, using graphical, numerical summary and interpretation. Discuss the second pairing of variables, using graphical, numerical summary and interpretation. Discuss the third pairing of variables, using graphical, numerical summary and interpretation. Conclusion

13) A box contains 5 green marbles, 6 blue marbles, and 8 red marbles. Three marbles are selected at random from the box, one at a time, without replacement. Find the probability that the first two marbles selected are not red, and the last marble is red. Round your answer to four decimal places.

What are two pieces of evidence that reliably point to a human cause for the increased CO2 in our atmosphere and for the observed global warming over the last 50 years?

Required information

[The following information applies to the questions displayed below.]

Arndt, Inc., reported the following for 2018 and 2019 ($ in millions):

1. Expenses each year include $20 million from a two-year casualty insurance policy purchased in 2018 for $40 million. The cost is tax deductible in 2018.
2. Expenses include $2 million insurance premiums each year for life insurance on key executives.
3. Arndt sells one-year subscriptions to a weekly journal. Subscription sales collected and taxable in 2018 and 2019 were $26 million and $31 million, respectively. Subscriptions included in 2018 and 2019 financial reporting revenues were $18 million ($7 million collected in 2017 but not recognized as revenue until 2018) and $26 million, respectively. Hint: View this as two temporary differences—one reversing in 2018; one originating in 2018.
4. 2018 expenses included a $15 million unrealized loss from reducing investments (classified as trading securities) to fair value. The investments were sold in 2019.
5. During 2017, accounting income included an estimated loss of $4 million from having accrued a loss contingency. The loss was paid in 2018 at which time it is tax deductible.
6. At January 1, 2018, Arndt had a deferred tax asset of $4 million and no deferred tax liability.

6. Suppose that during 2019, tax legislation was passed that will lower Arndt’s effective tax rate to 35% beginning in 2020. Prepare a schedule that reconciles the difference between pretax accounting income and taxable income. Using the schedule, prepare the necessary journal entry to record income taxes for 2019.

A researcher hypothesizes that people who believe in paranormal phenomena will obtain higher scores on the personality dimension of openness-to-experience. To test this belief, the researcher takes 8 randomly-selected people and gives them 2 tests: one is a 50-item test that measures the extent to which they endorse beliefs in paranormal phenomena and the other is a 30-item test that measures their openness-to-experience. The following data were obtained:

a) Do these data provide significant support for the researcher’s belief (α = .05)?

b) Use the data to generate a 95% prediction interval for the openness-to-experience score of a person with a paranormal beliefs score of 25.

For each of the following tests of hypotheses, determine whether the null hypotheses should be rejected. Use the classical method by finding the lower xL and upper xU limits for two-tail tests (or one of the two for a one-tail test). Additionally, don't forget to use a t-value (rather than a z-value) when n<30.

A) Ho: µ = 6,000 Ha: µ ≠ 6,000; n = 70; x = 6,150; σ = 2,600; α = .01

B) Ho: µ = 50 Ha: µ > 50; n = 24;  x = 55; s = 7; α = .05

C) Ho: µ ≥ 400 Ha: µ < 400; n = 56;  x = 350; s = 62; α =.03

# Please I need the answer by Excel with showing steps.

1/1/2020: Opened the business, invested $1,000,000 cash in the business.

1/1/2020: bought a building for the business purpose for $100,000 cash. The building has a useful economic life of 10 years.

1/1/2020: purchased 100 luxury watches for $200,000 with $100,000 cash payment, the remaining amount payable on 2/1/2021. (each watch costs $2,000)

3/1/2020: purchased 50 luxury watches for $250,000 with cash. Each watch costs $5,000.

4/1/2020: purchased 40 luxury watches for $240,000 with cash. Each costs $6,000.

6/1/2020: Sold 130 watched for $1,300,000. Of which $300,000 cash was received at the time of sale. The remaining amount to be received on 5/2/2021.

7/1/2020: paid $1,200 in advance for 12 months’ property insurance (7/1/20 to 7/1/21).

8/1/2020: borrowed $500,000 from a local Chase bank. Interest rate is 12%/year. Interest is paid every 6 months- the first payment date is 2/1/2021. Principal would be paid on 8/1/2021.

9/1/2020: to expand business, you rent a showroom in the next building. Paid $24,000 cash in advance for 12 month’s rent.

12/31/2020: Paid 2020 utilities expense, advertising expense, and miscellaneous expense for $5000, $15,000, and $4,000, respectively.

Salary is paid on the last day of each month. Each month’s salary expense is $20,000.

Notes:

• On 12/31/2020: Physical inventory showed that there were 60 luxury watches on hand at the end of the period. The company used periodic inventory system, and used FIFO costing method.
• Your business used straight-line depreciation method for all fixed assets.
• Ignore tax.

Requirement:

1. Prepare all journal entries, adjusting entries, closing entries needed for the period ending on 12/31/2020 based on above economic events

Question 7

1. The mean of a distribution is 50 and the standard deviation is 5. Between what to values will at least 75% of the data values fall? Blank 1 and Blank 2

Question 8

1. Twelve secretaries were given a typing test, and the times (in minutes) to completed it were as follows: 8, 12, 15, 9, 6, 8, 10, 9, 8, 6, 7, 8 Find the MEDIAN.

Question 9

1. Twelve secretaries were given a typing test, and the times (in minutes) to completed it were as follows: 8, 12, 15, 9, 6, 8, 10, 9, 8, 6, 7, 8 Find the VARIANCE. Round to one decimal place (example: 3.2)

Question 10

1. The mean of a distribution is 50 and the standard deviation is 5. Between what to values will at least 88.89% of the data values fall? Blank 1 and Blank 2