ADC B-Bit Quantizer of Sinusoidal Signal

question 13

Essay

ADC b-bit Quantizer of sinusoidal signal.Consider the following worksheet that shows ten
samples of a one-period sinusoidal waveform in Column B that has been matched to a b-bit
quantizer with Δ=1 and b specified in B1.The waveform amplitude that is matched to the
quantizer is computed in D1.Column C computes the quantizer level.Column D computes the
b-bit code using the Excel formula that converts a decimal value to its b-bit binary value.
a.What is the Excel formula in D1?
b.What is the Excel formula in B7?
c.What is the Excel formula in C7?
d.What is the Excel formula in D7?
$$\begin{array} { | c | c | c | c | c | } \hline & \text { A } & \text { B } & C & D \\\hline 1 & \mathrm {~b} = & 6 & \mathrm {~A} = & 63 \\\hline 2 & & & & \\\hline 3 & \mathrm { i } & \mathrm { s } _ { \mathrm { i } } & \mathrm { sq } & \mathrm { b } \text {-bit code } \\\hline 4 & 0 & 31.5 & 31 & 011111 \\\hline 5 & 1 & 50.0 & 50 & 110010 \\\hline 6 & 2 & 61.5 & 61 & 111101 \\\hline 7 & 3 & 61.5 & 61 & 111101 \\\hline 8 & 4 & 50.0 & 50 & 110010 \\\hline 9 & 5 & 31.5 & 31 & 011111 \\\hline 10 & 6 & 13.0 & 12 & 001100 \\\hline 11 & 7 & 1.5 & 1 & 000001 \\\hline 12 & 8 & 1.5 & 1 & 000001 \\\hline 13 & 9 & 13.0 & 12 & 001100 \\\hline\end{array}$$

---

Definitions:

Arithmetic Operations

Fundamental arithmetic processes including adding, subtracting, multiplying, and dividing.

Compound Interest

Interest calculation on a loan or deposit where the interest earned also earns interest, leading to exponential growth over time.

Nearest Cent

Rounding a monetary amount to the closest cent, often used to simplify cash transactions.

Simple Interest

An interest calculation method where the interest charge is calculated only on the principal amount, without compounding.