Question

Hypothesis #2    74% of participants chose to pick car parts

* I am attempting to display this as a statistical hypothesis with an alternative.

Data:

Those who did not order car parts 9

Those who ordered them at a warehouse 1

Those who Picked them up themselves 29

Those who had them delivered 0

I am having issues demonstrating the problem in a clean form with the use of excel.

Answer 1

The alternative to pick car parts is "did not order car parts". Therefore, the correct option should be "Those who did not order car parts 9".

But I would be needing more details about the question to answer it with more clarity.

Do you have any data set for this question?

I think you might be having more detailed information about this hypothesis, please share if possible.

It can be simply presented with a percentage or proportion in Excel. If you have any other specifications for this demonstration in Excel then share an example of what you're expecting. Or whole information might also help.