Hello!

I have some questions about multiple regression.

I have the data- 2 dependent variables ( not numerical) and a few independent variables ( not numerical), so I recoded them into dummy variables.

Data: one of the dependent variables:

I strongly consider information from Social Media Ad platforms in my purchase decisions of supplements ( neutral, strongly disagree, somewhat agree, somewhat disagree, strongly agree)

Independent variables: age ( 18-30, 30-50, 50-70+) Need to use dummy too?

gender ( male, female)

education; ( accociate, bachelors, master, doctorate)

income ( 10-40K$, 40-80K$, 80K$ up)

So my question is how I can convert the dependent variable "I strongly consider information from Social Media Ad platforms in my purchase decisions of supplements" into a numerical variable( I can assign numerical values to each response option. For example, I could assign "strongly disagree" a value of 1, "somewhat disagree" a value of 2, "neutral" a value of 3, "somewhat agree" a value of 4, and "strongly agree" a value of 5?

And which formula in Excel do I have to use for that? This is my main question.

I will be grateful for any help!

Thank you.